Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Getting result set from stored proc...

Getting result set from stored proc...

From: <sergey_s_at_my-deja.com>
Date: Wed, 01 Sep 1999 02:55:13 GMT
Message-ID: <7qi4ie$ng5$1@nnrp1.deja.com>


In Sybase or SQL Server I can have a straight SELECT statement within a stored procedure. For example:

create procedure sp_test as
select * from xyz;

When I call sp_test from outside (VB, C++, or whatever), I get the whole result set back and I can cycle through it using methods found in C++ or VB (I am using ODBC).

Oracle requires a SELECT INTO, however (or I could use a cursor). But how would I return the entire result set back to my VB or C++ program? Do I have to use OCI for that or is there some other way?

Thank you.
Sergey

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 31 1999 - 21:55:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US