In my database I have a stored procedure with an OUTPUT parameter of type SYS_REFCURSOR. The application side is wrtitten in C#. Can I assign this procedure\'s output parameter toa Datatable like:
We\'re going to write a new web interface for a big system based on Oracle database. All business rules are already coded in PL/SQL stored procedures and we\'d like to reuse as much code as possible.
I want to get the results in ref_cursor, but I am not able to do that. Please suggest me how to get the results in ref_cursor using Execute immediate
I\'m using a product that provides a database API based on Oracle functions and I\'m able to call functions via ODP.NET in general. However, I can\'t figure out, how to call a function that includes a
I am running an Oracle 9i server at my office.I am working on a procedure that passes a sys_refcursor as an out parameter to another package (along with other in parameters).I was able to define a typ
I am trying to call a function (oracle) using nhibernate that return ref cursor, but i am not successful with the hbm file, can any one please guide me with this.
I have a weird problem right now that if a ref cursor returned from a stored procedure that has only 1 record in it, the fetch operation will hang and freeze. The stored procedure execution was really
I\'m doing the following but it doesnt work select package_name.function_name(param,param) from dual I\'m calling a function that returns a cursor so im guessing \"from dual\" is the problem
I am trying to execute a user-defined Oracle function that returns a RefCursor using ODP.NET. Here is the function:
I am trying to execute a procedure that returns a stored procedure. My version of Oracle DB is 9.2 and the ODP .NET version is 10.2.0.100
加载中,请稍侯......