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

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

Re: stored procedure

From: Vadim Shatalov <skiv_at_admkom.tlt.ru>
Date: Thu, 21 Oct 1999 09:32:42 +0400
Message-ID: <395mu7.486.ln@news.admcity.tlt.ru>


> 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

Original text of this message

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