Top "Ref-cursor" questions

How to test an Oracle Stored Procedure with RefCursor return type?

I'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid …

oracle stored-procedures plsqldeveloper ref-cursor rapidsql
How to see refcursor result/output in Oracle SQL Developer?

Possible Duplicate: Best way/tool to get the results from an oracle package procedure Oracle SQL Developer: Show REFCURSOR Results …

oracle plsql oracle10g oracle-sqldeveloper ref-cursor
How to use record to loop a ref cursor?

I want to write PL/SQL to test a function in a package. The package defines a cursor type TYPE …

oracle plsql record ref-cursor
How to fetch Oracle reference cursor into table variable?

I am trying to load data from reference cursor into a table variable (or array), the reference cursor works if …

oracle stored-procedures ref-cursor
Calling a function that returns a refcursor

I am using Postgresql 8.3 and have the following simple function that will return a refcursor to the client CREATE OR …

sql postgresql cursor plpgsql ref-cursor
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 …

oracle function odp.net sys-refcursor ref-cursor
How to call a stored procedure using a ref cursor in Oracle with squirrel

I'm trying to do the same request I'm using in Toad (the stored procedure signature is two varchar2 parameter and …

oracle ref-cursor squirrel-sql
how to check if a ref cursor returns data from a pl/sql procedure

I would like to know how to check if a ref cursor returns data. Let's say I have the following …

oracle plsql cursor ref-cursor
How to return a empty cursor from a stored procedure?

I have OUT parameter of a stored procedure as a REF CURSOR. Based on a particular condition, I would want …

oracle stored-procedures cursor ref-cursor
Returning a ref cursor from a Oracle Function

I am getting the error - PLS-00382 Expression is of wrong type. I want to get the ref cursor as …

oracle plsql ref-cursor