RE: ora_check_sql in DBD::oracle

I didn't know about the "don't-parse-so-much flag" (ora_check_sql) until today. What's the "prefetch" one?

I typically also use a template rather than forcing myself to remember connect strings, e.g.:

	$dbh = DBI->connect("dbi:Oracle:$ENV{TWO_TASK}", $USER, $PASS) ||
		die "$DBI::errstr\n";
	$dbh->{RaiseError} = 1;		# die on any error
	$dbh->{AutoCommit} = 0;		# don't auto-commit

Rich

--
Rich Holland        (913) 645-1950        SAP Technical Consultant
print unpack("u","92G5S\=\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");



> -----Original Message-----

> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On

> Behalf Of Jared.Still_at_radisys.com

> Sent: Thursday, February 05, 2004 3:35 PM

> To: oracle-l_at_freelists.org

> Subject: RE: ora_check_sql in DBD::oracle

> 

> It's easy to forget stuff.

> Wish I could remember 10% more of everthing I've learned.  :)

> 

> In the case of perl, this is why I always build new scripts from a

> template

> that already has the prefetch and don't-parse-so-much flags set.

> 

> Jared

> 

> 

> 

> 

> 

> 

> "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>

> Sent by: oracle-l-bounce_at_freelists.org

>  02/05/2004 12:01 PM

>  Please respond to oracle-l

> 

> 

>         To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>

>         cc:

>         Subject:        RE: ora_check_sql in DBD::oracle

> 

> 

> Figures.  I thought I learned something new today.  Turns out that I just

> re-learned something I forgot:

> 

> http://www.mail-archive.com/dbi-users@perl.org/msg13613.html

> 

> Thanks for the reminder!  :)  But now I have to find something else new to

> learn today...

> 

> Rich

> 

> Rich Jesse                        System/Database Administrator

> rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI USA

> 

> 

> -----Original Message-----

> From: Mladen Gogala [mailto:mladen_at_wangtrading.com]

> Sent: Thursday, February 05, 2004 12:51 PM

> 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

> -----------------------------------------------------------------

> 

> 

> 

> 

> ----------------------------------------------------------------

> 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

> -----------------------------------------------------------------


----------------------------------------------------------------
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
-----------------------------------------------------------------