Re: ORA-1008 on Oracle 10g

Hello!
it seems there is a common interest for a solution for this case.

We solved this problem changing the Oracle parameter 'CURSOR_SHARING' from =
value 'force' to 'exact'. This fixes a known bug (or feature) introduced in=
Oracle 10.

After changing this parameter DBI works like with Oracle 9 before.

Hope this helps you to solve *your* problem.

Best Regards,
Olaf Ohlenmacher


--
Olaf Ohlenmacher
MaXpert AG, Berner Straße 119, 60437 Frankfurt am Main
Tel: +49 69 50065 269
Fax: +49 69 50065 515
Mobil: +49 172 6648 604


________________________________

Von: Olaf.Ohlenmacher@maxpert.de
Gesendet: Donnerstag, 14. Februar 2008 17:47
An: dbi-users@perl.org
Betreff: ORA-1008 on Oracle 10g



Hello!
i am writing a script querying a Oracle database with prepared stat=
ements. The database owner has upgradeed the database from version 9.2 to v=
ersion 10g.
Since this "upgrade" the scripts croaks() with

DBD::Oracle::st execute failed: ORA-01008: not all variables bound =
(DBD ERROR: OCIStmtExecute) [for Statement "
SELECT *
FROM
BB_TO_SYS_MESSAGE
WHERE
STATUS =3D 'new' AND
BACKBONE_TICKET_ID =3D ? AND
TIMESTAMP =3D ?
" with ParamValues: :p1=3D'Ticket-SC-GER-20080214153230054', :p2=3D=
'2008-02-14 15:39:38'] at D:/Programme/backbone-devel/Programme/DBhandling.=
pm line 459

There are only two parameters :p1 and :p2 with both have valid valu=
es.

Have you any suggestion why this statement failed on Oracle 10g?
Do you know about any problems with the module version i am=
using (see below)?

Using this version...

ActiveState perl 5.8.8
DBI 1.601
DBD-Oracle 1.17

All from ActiveState Package Repository.

Best Regards,
Olaf Ohlenmacher
--
Olaf Ohlenmacher
MaXpert AG, Berner Straße 119, 60437 Frankfurt am Main
Tel: +49 69 50065-265
Mobil: +49 172 6648 604