Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL, VB5, ODBC & Resultsets
You'll need to be using the 8.0.5 ODBC driver, as it's the first version
that supports resultsets being returned from stored procedures. Then, you
just open an RDO recordset calling your stored procedure, and the cursor
variable that it returns will become the RDO recordset, just like it would
have for SQL Server.
Dieselm wrote in message
<1998090400223400.UAA02301_at_ladder03.news.aol.com>...
>Hello:
>I need to return a result set from Oracle 8 into a VB5 program using
ODBC/RDO.
>I mostly program in MS SQL Server and this is accomplished easily ie:
>
>select * from table1
>
>That is all that is required in a stored procedure. I can reference each
column
>in the VB app rdoobj!col1, rdoobj!col2 etc.
>
>How do I accomplish the same thing in Oracle PL/SQL? I've written packages
that
>return a cursor variable and used it in SQL/Plus but that is useless in a
vb
>app where I cant define a cursor variable.
>
>Thanks!!
>
Received on Thu Sep 03 1998 - 19:25:49 CDT