Help! ODBC calling PL/SQL package REF CURSOR?
From: Richard Weatherley <richardw_at_enternet.com.au>
Date: 1997/06/30
Message-ID: <33B7B5B6.1F7EF21_at_enternet.com.au>#1/1
Date: 1997/06/30
Message-ID: <33B7B5B6.1F7EF21_at_enternet.com.au>#1/1
Hi all
I am trying to access a PL/SQL function within a CREATEd package using ODBC 3.0/Oracle driver 2.0.3.1.1 with Visual C++ 4.0, NT 4.0 and Oracle 7.3 on DEC UNIX. It seems ODBC can't access the function using "? = call pkgname.fn(?)" syntax. Does anyone have a solution?
Also, does anyone know how to pass a PL/SQL type REF CURSOR back to a calling ODBC program? Is it just a result set? Is it possible?
Thanks
--Richard. Received on Mon Jun 30 1997 - 00:00:00 CEST