Re: Query in a Stored Procedure

On Thu, 30 Aug 2001 05:41:54 -0700, "Roman Sochan" <rsochan_at_removeme.ix.netcom.com> wrote:

>
>How would I convert the above into PL/SQL and store it as a procedure, or am
>I not able to store queries in an Oracle stored procedure?
>

There are some very good examples on how to return output from stored queries in the PL/SQL manual, the section that deals with cursors and REF cursors.
As for direct conversion tools, there are some previous messages here on tools available to do it automagically. Try google.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Aug 30 2001 - 07:49:41 CDT