Re: Bulk bind in Native Dynamic SQL

Igor,

The drawback with that method is that you have a 1:1 parse:execution ratio.

Jared

"Igor Neyman" <ineyman_at_perceptron.com>
Sent by: root_at_fatcity.com
 04/18/2003 06:48 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: Bulk bind in Native Dynamic SQL

Waleed,

"EXECUTE IMMEDIATE" example I suggested instead of ref cursor. As for "bulk collect" in "EXECUTE IMMEDIATE" with "INTO" clause - it definitely works in my application (and has been working for coupe years, since 8.1.5 came out).

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, April 17, 2003 11:36 PM

> The start of the discussion had to do with bulk reading from a ref
cursor
> that opens a dynamic sql.
>
> This is not available in 8i.
>
> Also regarding the INTO clause of EXECUTE IMMEDIATE:
>
> INTO ...
> Used only for single-row queries, this clause specifies the variables or
> record into which column values are retrieved. For each value retrieved
by
> the query, there must be a corresponding, type-compatible variable or
field
> in the INTO clause.
>
> Regards,
>
> Waleed
>
>
> -----Original Message-----
> Sent: Thursday, April 17, 2003 5:27 PM
> To: Multiple recipients of list ORACLE-L
>
>
> EXECUTE IMMEDIATE 'select oid BULK COLLECT from ' || TABLE_NAME || '
where
> ...'
> INTO l_oid
> USING ...
>
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).