Re: Return recordsetfrom pl/sql

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 03 Feb 2004 20:57:08 +0100
Message-ID: <m7vv101ltlsl0e111th9vpbg2cnda2di7p@4ax.com>

On Tue, 3 Feb 2004 13:33:29 +0000 (UTC), John <Nothanks_at_noaddress.com> wrote:

>Is it possible to run a query (oo4o) and return a recordset from a pl/sql
>block like what would be returned from a select whatever from wherever?
>
>
>
>Cheers

Yes, look up 'REF CURSOR' in the doco.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Feb 03 2004 - 13:57:08 CST

This message: [ Message body ]
Next message: Daniel Morgan: "Re: Oracle Trigger"
Previous message: Andy Hassall: "Re: Oracle Trigger"
In reply to: John: "Return recordsetfrom pl/sql"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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