| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora_check_sql in DBD::oracle
Thanks Mladen and Cary. Isn't this similar to Case 3 in Chapter 12 in Cary
and Jeff's book?
John
>-----Original Message-----
>From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
>Sent: Thursday, February 05, 2004 10:51 AM
>To: Multiple recipients of list ORACLE-L
>Subject: ora_check_sql in DBD::oracle
>
>
>In private communication with Cary Millsap, I was warned about the
>undocumented DBI handle attribute called "ora_check_sql" which was
>defaults to "1" and, oracle versions 8 and above, causes oracle to
>parse each statement twice ($sth=$dbh->prepare() is the first parse
>and 4sth->execute() was the second). On 1/27/2004. Tim Bunce delivered
>the new DBD::Oracle v1.15 and in the documentation one can find the
>following text:
>***************************************************************
>************
>ora_check_sql
>
> If 1 (default), force SELECT statements to be described in prepare
>(). If 0, allow SELECT statements to defer describe until execute().
>(OCI8 and later only.)
>
> See "Prepare postponed till execute" for more information.
>***************************************************************
>***********
>
>When I did the unthinkable and read the documentation (I know,
>real DBA
>is not supposed to read the documentation, but learn by osmosis) I
>remembered the correspondence with Cary and decided to publish it for
>the rest of the good, hard hacking, perl folks.
>
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Feb 05 2004 - 13:07:46 CST
 |
 |