Re: stored procedure

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Mon, 18 Oct 1999 17:31:35 GMT
Message-ID: <XPIO3.48$p%6.1778566@France.EU.net>

Hi Larry !

If you make a "select... into..." query, the select must return only one row !
It must be true every times ! (it depends on your application )

If your SQL returns more than one, you have to code a cursor FOR c IN (SELECT ...) LOOP

• initial statement END FOR ;

Larry Pettit <larry.pettit_at_ps.net> a écrit dans le message : Z9IO3.194$qE6.15972_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 Mon Oct 18 1999 - 12:31:35 CDT