Re: Return Table datatype from SP through JDBC/ODBC

On Tue, 21 Apr 1998 11:39:28 +0200, Mikael Schonenberg <micke_at_netg.se> wrote:

> Greetings, my friends.
>
> This questions is actually more conserned with Java than Oracle I
>believe, but this seems like a place where I might be able to get an
>answer.
>
> Our problem is that we can not execute Stored Procedures (or rather
>functions actually) that return a table datatype when connecting to the
>database (Oracle 7.3, NT) through ODBC or JDBC. Sending tables between
>stored procedures is not a problem (at least not now when I've figured out
>that the table datatype to be sent needs to be globally defined first),
>and calling functions that return primitive datatypes from the outside is
>not a problem either. But when trying to execute a PL/SQL function in the
>database that returns a table datatype and take care of that table in an
>external application (in this case an ActiveX object coded in Java), we
>just can't get it to work. Any ideas anyone?
>
>/Mikael

The MS ODBC driver for Oracle supports this, (version 2.7x - check the help file), this is how they implement result sets from Stored Procedures with Oracle. The Oracle JDBC drivers do not, nor does the ODBC driver, (table types that is). Received on Tue Apr 21 1998 - 07:28:06 CDT