Re: stored procedures and return sets
Date: 1995/10/16
Message-ID: <DGJysG.838_at_intruder.daytonoh.attgis.com>#1/1
It is possible to get results sets back from stored procedures.
You do need an interface (possible oci) to invert
the returned columns. What you are getting returned are arrays
of columns (ie all of column 1 followed by all of column
2 etc etc.
>==========Terry Traub, 10/16/95==========
>
>Hi,
>I'm a convert to Oracle from the Sybase religion, and I was hoping to
>do a Sybase-type thing: write a stored procedure with a SELECT
>statement that returns many rows, and call it from a Pro*C program
>or from a Windows program via ODBC.
>
>I read through the Oracle 7.1.4 manuals, which seem to carefully skirt
>this issue completely; every single example of a stored procedure is
>an update rather than a SELECT, and the closest to a return set
>indicated is the IN/OUT parameter feature.
>
>Is it therefore true that you can't get return sets from stored
>procedures? This has been a standard feature of Sybase for so long
>that I am very surprised at its omission in Oracle.
>
>Terry Traub
>
Received on Mon Oct 16 1995 - 00:00:00 CET