Tags » Ref Cursor

PL/SQL- Ref Cursor

Limitations of a normal cursors are —
1) A PL/SQL program cannot pass a cursor as a parameter to another program.
2) A PL/SQL program can only open the cursor and process the information within the program itself. 965 more words

Oracle

Ref Cursors Oracle

The REF CURSOR is a data type in the Oracle. REF CURSOR also referred as Cursor Variables.Cursor variables are like pointers to result sets. Cursor can be attached to only one query while REF CURSOR can be used to associate multiple queries at run time.  244 more words

Oracle

HOW TO CHECK IF A REF CURSOR RETURNS DATA FROM A PL/SQL PROCEDURE

create or replace procedure sp_is_refcursor_null (v_cursor OUT SYS_REFCURSOR)
AS
v_rec number;
BEGIN
 OPEN v_cursor FOR
  select 1 from dual where 1=0;
 fetch v_cursor into v_rec;
 if v_cursor%found then
  dbms_output.put_line('CURSOR NOT NULL');
 else
  dbms_output.put_line('CURSOR NULL');
 end if;
END;
/
ORACLE

Working with REF Cursors - With Examples

A ref cursor is a variable, defined as a cursor type, which points to, or references a cursor result. A cursor variable which is based on REF CURSOR data type can be associated with different queries at run-time.  437 more words

SQL-PL/SQL

Calling and exiting SQLPlus from a DOS batch file dynamically

Suppose you want to run a SQL*Plus script from a DOS batch file. The SQL*Plus script does not contain an exit-statement. Yet, you want SQL*Plus to return control to the DOS batch script so you can do some other stuff as well, and you certainly don’t want to type “exit” every time. 110 more words

Oracle

Fetch from a refcursor returned by a function or stored procedure

My web application accesses the database using packages. These packages contain procedures that return refcursors. To test these packages, I searched for a way to easily call the procedures and make the resultset visible. 102 more words

Oracle

Getting APEX to play with Ref Cursors

It’s that time of year again. Things are a bit tense around the house.
The other morning, I woke up to find that someone had placed a leek in my slippers. 1,314 more words

Oracle