Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL, VB5, ODBC & Resultsets
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:22:34 CDT