Re: PL/SQL, VB5, ODBC & Resultsets

From: <avilner_at_my-dejanews.com>
Date: Mon, 14 Sep 1998 16:15:13 GMT
Message-ID: <6tjfeh$4kv$1@nnrp1.dejanews.com>

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