Re: Oracle Stored Procedures (?)
From: Graeme Sargent <graeme_at_pyramid.com>
Date: 1995/04/20
Message-ID: <3n6q4o$9a9_at_sword.eng.pyramid.com>#1/1
Date: 1995/04/20
Message-ID: <3n6q4o$9a9_at_sword.eng.pyramid.com>#1/1
jon glickman (jglickma_at_lynx.dac.neu.edu) wrote:
: Can anybody recommend how to return a result set from a Oracle
: stored procedure... There is an example of this on page 2-68 of the
: PL/SQL manual... basically I need to return all the rows from a
: select (select * from scott.emp) ....
Well, you could wait for 7.2, which implements a sane way of doing it!
--
graeme
--
Disclaimer: The author's opinions are his own, and not necessarily
those of Pyramid Technology Ltd. or Pyramid Technology Inc.
---------------------------------------------------------------------------
-m------- Graeme Sargent Voice: +44 (0)252 373035
---mmm----- Senior Database Consultant Fax : +44 (0)252 373135
-----mmmmm--- Pyramid Technology Ltd. Telex: Tell who???
-------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme_at_pyra.co.uk
---------------------------------------------------------------------------
We have the technology. The tricky bit is learning how to use it.
Received on Thu Apr 20 1995 - 00:00:00 CEST