cursor in stored procedure in oracle [modified]
-
hello everyone.. i have a problem regarding in using sursor in oracle 10i. how can i pass to a cursor the output from stored procedure? like this one: CURSOR cur1 IS SAMPLESP(); --sample stored procedure. but when itry this i get this error: PLS-00103: Encountered the symbol "SAMPLESP()" when expecting one of the following: ( select please help.. thanks in advance.
jyn
modified on Tuesday, November 18, 2008 6:33 AM
-
hello everyone.. i have a problem regarding in using sursor in oracle 10i. how can i pass to a cursor the output from stored procedure? like this one: CURSOR cur1 IS SAMPLESP(); --sample stored procedure. but when itry this i get this error: PLS-00103: Encountered the symbol "SAMPLESP()" when expecting one of the following: ( select please help.. thanks in advance.
jyn
modified on Tuesday, November 18, 2008 6:33 AM
cursors are passed as inputs to stored procedures in oracle and the stored procedure then assigns them.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
Most of this sig is for Google, not ego. -
hello everyone.. i have a problem regarding in using sursor in oracle 10i. how can i pass to a cursor the output from stored procedure? like this one: CURSOR cur1 IS SAMPLESP(); --sample stored procedure. but when itry this i get this error: PLS-00103: Encountered the symbol "SAMPLESP()" when expecting one of the following: ( select please help.. thanks in advance.
jyn
modified on Tuesday, November 18, 2008 6:33 AM
To add to the previous post, the technological term for this is
REF CURSOR. For more information, see PL/SQL User's Guide and Reference Chapter 6 Performing SQL Operations from PL/SQL Using Cursor Variables (REF CURSORs) MikaThe need to optimize rises from a bad design. My articles[^]