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 -> How do I return a recordset from a stored procedure

How do I return a recordset from a stored procedure

From: Phil Goden <noble_at_audiophile.com>
Date: Sat, 11 Aug 2001 02:23:42 +0100
Message-ID: <HL%c7.16514$tq.1808338@news6-win.server.ntlworld.com>

Hello,

I am new to Oracle. I am trying to return the result of a simple query through a stored procedure.

What I have inside the stored procedure look like this:

    select * from table_a where field1 = 'value'

When I execute the stored procedure from SQLPlus, I would like the result to look as though I had execute the select statement directory.

Can anyone help?

---
Phil
Received on Fri Aug 10 2001 - 20:23:42 CDT

Original text of this message

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