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?>[EMAIL PROTECTED] >
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/[EMAIL PROTECTED]
