Re: 10g Bind peeking causes multiple cursors for same query with perl DBD::Oracle

Just for completeness sake, I contacted the dbi-users_at_perl.org users group and the solution to my problem was to call the prepare() with an additional parameter.

instead of "my $sth = $dbh->prepare($sql);"

do the following

$dbh-> "my $sth = $dbh->prepare($sql, {ora_check_sql => 0} );

The default to ora_check_sql = 1 which causes that extra parse for SELECT statements.
Changing the variable to 1 causes the parse and execute to be done at the same time resulting in
only 1 cursor.

perldoc DBD::Oracle ... then search for ora_check_sql

--peter Received on Tue Dec 13 2005 - 14:22:42 CST