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