Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: stored procedure
> 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.
It's possible if you have Oracle ver.7.3. or higher.
Begin this version Oracle can return cursor from procedure.
Received on Thu Oct 21 1999 - 00:32:42 CDT
![]() |
![]() |