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

In article <9512111254.AA13381_at_enzomc>, emaini_at_sikorsky.com (Enzo Maini) writes:
|> 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.

Oracle 7.2 has a much cleaner interface for this - cursor variables. A stored procedure can open the cursor variable for a particular query, and then you fetch from it on the client. You need Pro*C or OCI to use this currently. I would expect VB and Power Builder to implement some sort of support for this in the future.

|>
|> 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 Wed Dec 13 1995 - 00:00:00 CET