[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    AW: calling stored procs
From:       "Anhaus, Thomas" <thomas.anhaus () sap ! com>
Date:       2004-08-10 5:34:17
Message-ID: 73DFF891F8024B48AD56B594C4C5038A0C5B2B () dewdfe23 ! wdf ! sap ! corp
[Download RAW message or body]

Jason Foreman wrote :
>
>I am curious how, if possible, I can call procedures that return a 
>cursor from within another procedure.  For example, I have two 
>procedures that return a cursor, i want to get those cursors and use 
>them in another procedure.  Is this possible?  Something like:
>
>create dbproc foo returns cursor as
>$cursor = 'foo';
>declare :$cursor cursor for select * from foo;
>
>create dbproc bar returns cursor as
>$cursor = 'bar';
>declare :$cursor cursor for select * from bar;
>
>-- don't know how to write the following procedure....
>create dbproc baz as
>call foo;  <--- how do i use the cursor returned from this procedure??
>call bar;
>select foo.a, bar.a from foo, bar;
>
>Thanks for the help,
>
>Jason
>
>
>-- 
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe:    
>http://lists.mysql.com/maxdb?>unsub=thomas.anhaus@sap.com
>

Sorry, but it's not yet possible to access the cursor returned by a procedure
inside another procedure. This would require a dynamic fetch statement, which is
not yet available.

Best Regards,
Thomas

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]