How to call a SQL function which returns a cursor

Author	Topic
sri k Member Joined: 27 Feb 2008 Country: Posts: 2	Posted: 03 Mar 2008 13:07:22 Hi i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c# i have tried to call using OracleCommand.CommandType = CommandType.StoredProcedure OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32); p_case_action_id.Direction = ParameterDirection.Input; p_case_action_id.Value = intSourceID; orlCmd5.Parameters.Add(p_case_action_id); but it's throwing an exception saying invalid arguments or saying the function name is invalid i even tried to call the function using CommandText rather than storedprocedure and the result is same errors Function -------------- FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor; Thanks in advance Sri Hi i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c# i have tried to call using OracleCommand.CommandType = CommandType.StoredProcedure OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32); p_case_action_id.Direction = ParameterDirection.Input; p_case_action_id.Value = intSourceID; orlCmd5.Parameters.Add(p_case_action_id); but it's throwing an exception saying invalid arguments or saying the function name is invalid i even tried to call the function using CommandText rather than storedprocedure and the result is same errors Function -------------- FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor; Thanks in advance Sri

Author

Topic

sri k
Member

Joined: 27 Feb 2008
Country:
Posts: 2

Posted: 03 Mar 2008 13:07:22

Hi

i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c#

i have tried to call using
OracleCommand.CommandType = CommandType.StoredProcedure
OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32);
p_case_action_id.Direction = ParameterDirection.Input;
p_case_action_id.Value = intSourceID;
orlCmd5.Parameters.Add(p_case_action_id);

but it's throwing an exception saying invalid arguments or saying the function name is invalid

i even tried to call the function using CommandText rather than storedprocedure and the result is same errors

Function
--------------
FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor;

Thanks in advance
Sri

Hi

i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c#

i have tried to call using
OracleCommand.CommandType = CommandType.StoredProcedure
OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32);
p_case_action_id.Direction = ParameterDirection.Input;
p_case_action_id.Value = intSourceID;
orlCmd5.Parameters.Add(p_case_action_id);

but it's throwing an exception saying invalid arguments or saying the function name is invalid

i even tried to call the function using CommandText rather than storedprocedure and the result is same errors

Function
--------------
FUNCTION get_student_data(studentid IN NUMBER) RETURN case_cursor;

Thanks in advance
Sri

Main Sponsor

Visit All Zones

Latest Components

Our Sponsors

Featured Article

Beyond Graphing

When a graph is drawn, the focus is kept on the actual underlying competing figures that constitute the graph. Sometimes it is difficult to make assumptions just by looking at these graphs. When looking at a geographical map of data you immediately see exactly where things are happening. This article presents a .NET geographical mapping solution that will illustrate a fairly simple way of implementing these maps.

Featured E-Book

Design & Accessibility

Have you, as a web developer or designer ever been on sites where the site seems more of a puzzle then a tool to find the information you where looking for? Or are you looking to improve your web design skills? Then read on!

Design & Accessibility

This e-Book will teach you how to become a truly professional developer or designer. By taking usability and accessibility issues in account when designing your websites or applications you can make the difference and avoid a lot of (user) frustration.

Featured Component

3D Gal Slideshow Bndl

Get our best gallery and slideshow components in one bundle and save money! Our most popular components combined to form an amazing presentation team.

Featured Book

Inside ASP.NET

Inside ASP.NET is a comprehensive guide to ASP.NET development using Microsoft's .NET development framework. This book presents information on the .NET framework that is of specific interest to Internet and intranet developers, and is split into the following sections: Introducing ASP.NET, Core ASP.NET, ASP.NET and Data Access, Advanced Technologies, Advanced Web Forms, and Putting It All Together

Each chapter tackles a specific area of ASP.NET development, first by giving a detailed overview, then presenting a series of code examples and walk-throughs that illustrate various applications of ASP.NET

How to call a SQL function which returns a cursor

Main Sponsor

Visit All Zones

Latest Components

Our Sponsors

Featured Article

Featured E-Book

Design & Accessibility

Featured Component

Featured Book

DNzone

The Nuts and Bolts for Creative Web Development