Re: Can Stored Procs return a result query???

From: Enzo Maini <emaini_at_sikorsky.com>
Date: 1995/12/11
Message-ID: <9512111254.AA13381_at_enzomc>#1/1


In General, Oracle Stored Procedures return only a single value. However, If you are using Oracle 7.1 or greater you can use a Package called DBMS_SQL. This will allow to perform Dynamic SQL on the server side and will allow you to return more than one row.

For more information on the package look in the data dictionary in the table dba_source.

For a more verbose step by step example, check out the book ORACLE PL/SQL from O'Reilly & Associates, Inc ISBN 1-56592-142-9. This invaluable book if you are dealing with Oracle. While you are at the book store, check out books from Oracle Press. There are books on the server and even Personal Oracle that should help you with NT.

  • Enzo

In article <30C6584F.F3E_at_ix.netcom.com>, Steve Perry <dpsmp_at_ix.netcom.com> writes:
> Path: cronkite!psinntp!psinntp!psinntp!howl
> and.reston.ans.net!ix.netcom.com!netnews From: Steve Perry
> <dpsmp_at_ix.netcom.com>
> Newsgroups: comp.databases.oracle
> Subject: Can Stored Procs return a result query???
> Date: Wed, 06 Dec 1995 18:58:23 -0800
> Organization: Netcom
> Lines: 8
> Message-ID: <30C6584F.F3E_at_ix.netcom.com>
> NNTP-Posting-Host: ix-or12-12.ix.netcom.com
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-NETCOM-Date: Wed Dec 06 6:55:29 PM PST 1995 Mailer:
> X-Mozilla 2.0b2 (Windows; I; 32bit)
>
> I'm used to using VB and SQL server. With it I can call a stored
> procedure and have it return 1 or many rows of data. How is this done
> in Oracle. Can someone show me an example definition???
>
> Where can I get more information on Oracle on NT?
>
> Thanks,
> Steve
Received on Mon Dec 11 1995 - 00:00:00 CET

Original text of this message