Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL, VB5, ODBC & Resultsets
I just upgraded to client version 8.0.5.
I am getting the error:
Runtime error '40002':
S1000:[Oracle][ODBC][Ora]ORA-06550:line 1 column 45:
PLS-00103: Encountered symbol "{" when expecting one of the following ....
It happens on the line where I open the result set:
Set rs = MyQuery.OpenResultset()
, where
MyQuery.SQL = "{CALL STOREDPROCEDURETEST.GETPROPHDRRECORDS({resultset 1000,
ao_prop_record})}"
And the procedure in Oracle is defined as: CREATE OR REPLACE PACKAGE StoredProcedureTest AS
TYPE t_PROP_HDR_142 is TABLE OF PROP_HDR_142%ROWTYPE INDEX BY BINARY_INTEGER; PROCEDURE GetPropHdrRecords( ao_prop_record OUT t_PROP_HDR_142 );END StoredProcedureTest;
Any suggestions?
In article <hsGH1.33259$435.12951874_at_news.rdc1.az.home.com>,
"Kevin P. Fleming" <kfleming_at_access-laserpress.com> wrote:
> 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!!
> >
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 14 1998 - 11:15:13 CDT