Re: What if no REF CURSOR...?

In article <974203455.29386.0.nnrp-02.c2de47d8_at_news.demon.co.uk>,   "Ian Carrick" <ian_at_rombus.co.uk> wrote:
> Some questions I would like answering about Oracle 8i/VB/ADO.
>
> 1) Is it true that MS OLEDB Provider for Oracle does not support
 REF
> CURSOR?
> 2) If I want to run a different SELECT statement depending on an
 argument
> I pass into a procedure, how would I do it? Could it be done without
 REF
> CURSORS?
> 3) How do you return a result set as an OUTPUT argument in a
 procedure
> without using REF CURSORS?
>
> The reason for these questions are that I'd like to use MS OLEDB
 rather than
> Oracle OLEDB and need to get a result set back without using REF
 CURSORS.
> At the same time I would like to be ably to dynamically create the SQL
> statement dependin on arguments supplied in the procedure.
>
> Cheers for help.
>
>

If you want to return a resultset use of REF CURSORS is mandatory. There are no other options. In 8i you can use dynamic sql statements in conjunctions with your ref cursor. Just define a weakly typed REF CURSOR and use OPEN <cursorvar> FOR :<sqlstring>;

Hth,

Sybrand Bakker, Oracle DBA

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.