Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] How to return a result set from a stored procedure through ODBC?
Within an ORACLE stored procedure, you use a CURSOR to get your result set (the cursor is your SELECT statement). You can OPEN this cursor, FETCH one row at a time and manipulate as you wish, then CLOSE the cursor. You can do similar things with the PRO*C pre-compiler if working with 'C'.
Hope this helps.
Wayne Linton
Shell Canada Ltd.
Received on Sat Jul 05 1997 - 00:00:00 CDT