Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: stored procedure
YOU HAVE TO USE CURSORS WHEN MULTIPLE ROWS ARE RETURNED
VIJI
Larry Pettit <larry.pettit_at_ps.net> wrote in message
news:P8IO3.193$qE6.17205_at_news.uswest.net...
> I've created and tested several stored procedures from SQL*plus. They
work
> just fine when they only return 1 row. It seems that SQL*Plus won't allow
> multiple rows to be returned. Do I need to do something different in my
> procedures, or is it just impossible to test from SQL *plus.
>
> Thanks.
>
>
Received on Tue Oct 19 1999 - 10:42:23 CDT