stored procedures

If a store procedure returns only one row, I use the select/into format, otherwise I use a cursor with a loop.

Is there any other way to return multiple rows. We're using a visual c++ client and it works with only one row but it's not working when the stored procedure (with a cursor) returns many.

It works fine both ways in SQL *PLUS

Any suggestions?
Thanks. Received on Wed Nov 10 1999 - 15:55:41 CST