Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: stored procedure

Re: stored procedure

From: udaj <udaj_at_email.msn.com>
Date: Tue, 19 Oct 1999 11:42:23 -0400
Message-ID: <u8#$xgkG$GA.249@cpmsnbbsa03>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US