sys-refcursor

相关标签：javascript jquery android 多少钱 iPhone

Using ouput parameter of type SYS_refcursor

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:[详细]

2023-04-12 23:44 分类：问答
passing data from Oracle stored procedures to Java

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.[详细]

2023-04-04 23:15 分类：问答
Ref cursor with Execute immediate

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[详细]

2023-03-15 11:01 分类：问答
How to call an Oracle function with a Ref Cursor as Out-parameter from C#?

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[详细]

2023-03-13 00:38 分类：问答
Get specific fields from sys_refcursor in stored proc?

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[详细]

2023-03-06 09:49 分类：问答
nhibernate, call function in Oracle which returns sys refcursor

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.[详细]

2023-03-02 22:23 分类：问答
Oracle ref cursor fetch hangs if it contains 1 single record

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[详细]

2023-02-14 01:01 分类：问答
How to call a function in a package

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[详细]

2023-02-02 14:18 分类：问答
How to return a RefCursor from Oracle function?

I am trying to execute a user-defined Oracle function that returns a RefCursor using ODP.NET. Here is the function:[详细]

2023-01-23 20:58 分类：问答
ODP .NET Getting a SYSREFCURSOR output. {"Unsupported column datatype"} error

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[详细]

2023-01-11 02:54 分类：问答