Re: Use cursor with stored procedure

your cursor should be OUT, not IN OUT.

-- 
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
[Quoted] Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
[Quoted] All opinions are mine and do not necessarily go in line with those of my employer.


"Vavail Fred" <vavail_at_caramail.com> wrote in message news:a8rrc3$vl8$1_at_s1.read.news.oleane.net...


> Hi there !


> 

> I have a problem writing a procedure which return a cursor.

> Firstly, I declare my cursor in a package ...

> 

> PACKAGE p_test

> as

>   cursor orga is select nom_orga, adr1_orga from t_organisme;

>   type CurseurTest is ref cursor return orga%rowtype;

> end p_test;

> 

> ... and then, here is the procedure which have to return the cursor :

> 

> PROCEDURE my_proc ( curseur in out p_test.CurseurTest, nom_orga out

> varchar2, adr1_orga out varchar2)

> as

> begin

>   open curseur

>   for

>   select nom_orga, adr1_orga

>   into nom_orga, adr1_orga

>   from t_organisme;

> 

> end;

> 

> My package and my procedure are fine compiled.

> But I can't succeed to run it !

> Have you any idea to run that correctly ?

> 

> TIA

> 

> Best regards,

> Fred

> 

>