Re: Newbie PL/SQL Question

Your procedure needs to have a ref cursor as in/out parameter. The website of Thomas Kyte ( http://osi.oracle.com/~tkyte ) has examples.

Hth,

--
Sybrand Bakker, Oracle DBA
Frank Blau <blaus_at_ix.netcom.com> wrote in message news:83h95a$l5i$1_at_nntp3.atl.mindspring.net...
> In Transact-SQL, I can write a stored procedure to return a selection of
> records to the client... just by writing a select statement in the SP.
>
> Is it my imagination, or is this a lot more code to write in PL/SQL?
>
> I am looking at the page that talks about how you can only return one row
> with a select statement, unless you use cursors and step through the
> selection one row at a time...
>
> am I missing something obvious?
>
> Frank
>
>
Received on Sat Dec 18 1999 - 23:14:28 CST