DBD::Oracle, cursor_sharing, and ORA-01008

[Andrew McFarlane]

I ran into a problem with queries executed on an intranet site.  The web 
server was running with Apache on a Windows XP Pro machine using DBI 1.53 
and DBD::Oracle 1.19.  The database server was upgraded from Oracle 10.2.0.2 
to 10.2.0.3.

As soon as the upgrade happened, all of my queries failed that were using 
bound variables with the error: ORA-01008:	not all variables bound

I found a message on forums.oracle.com ( 
http://forums.oracle.com/forums/thread.jspa?messageID=1647779&#1647779 ) 
that described the same issue as I was having.  As you can see from that 
thread, the resolution was to change the server setting of cursor_sharing to 
EXACT.

Other Oracle clients such as SQL*Plus were able to query the server 
successfully before the configuration change was made.

My questions are--why did I have to make the configuration change?  Why can 
SQL*Plus handle the queries but Oracle::DBD 1.19 could not?

Thanks.

Andrew McFarlane

_________________________________________________________________
Valentine’s Day -- Shop for gifts that spell L-O-V-E at MSN Shopping 
http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&tcode=wlmtagline