RE: ora_check_sql in DBD::oracle
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Feb 2004 11:07:46 -0800
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@xxxxxxxxxxxxxxx]
>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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
