Re: Question on How to call a Select stmt in a Stored Procedure ?

I did not see the original article , but you might want to look into Oracle 'Database Pipes' to communicate between Pro*C and a Stored Procedure.

Also, Plsql Tables (arrays) are available from 1 called stored procedure to the next, within the SAME Oracle 'connect session'. Global arrays (or variables) do not have to be passed because they are available for the duration of the Oracle 'connect session'.

• Forwarded Article Below --

Jason Lisenchuk <hris_at_nt.com> writes:

>Question on How to call a Select stmt in a Stored Procedure ?
 

>Please keep in mind that Oracle 7.0.x stored procedures cannot return a
>cursor; instead return a scalar value (like NUMBER or VARCHAR or LONG).
>If the SELECT contained within the procedure retrieves a small amount of
>data, you could consider packing this into a LONG (with appropriate
>delimiters) and parsing via C at the client. Alternatively, you could
>use the SELECT to summarize data and INSERT it into another table, which
>you SELECT and FETCH via C at the client.
 

>I am hopeful that this will be fixed in a future version of Oracle. I
>would also like to be able to call a C module from within a stored
>procedure.
 

>Jason Lisenchuk
>ESN 334-7879

--
*****************************************************
* Burt Peltier ..................... burt_at_shell.com *
* Shell Offshore Inc.                (504) 588-0179 *
* 701 Poydras St. Rm.1660                           *