Do a search in the newsgroup. This is answered almost daily. Also look in
the documentation.
Jim
"Olaf F. Normann" <olafn_at_runit.no> wrote in message
news:1001591909.104726_at_halvan.trd.sintef.no...
> I'm a newbee to Oracle, but have quite a lot experience with
> Microsoft SQL Server and Sybase.
>
> I'm used to use stored procedures to retrieve multiple records (rows)
> from it, and in my client program (VBScript in .asp pages), handle
> it much the same way as if I used a Select statement.
>
> But this seems impossible in Oracle, it complain that I must send
> the result from the Select statement into variables:
> (SELECT field1, field2 INTO var1, var2 FROM table1).
>
> How can I use stored procedures (or functions) to retrieve multiple rows?
>
> Please help!
>
> Olaf F. Normann,
> Runit AS, Norway
> email: olafn_at_runit.no
>
>
Received on Thu Sep 27 2001 - 07:05:45 CDT
