Front page | perl.dbi.users |
Postings from April 2008
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 <Olaf.Ohlenmacher@maxpert.de>
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 statements. The database owner has upgradeed the database from version 9.2 to version 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 = 'new' AND
BACKBONE_TICKET_ID = ? AND
TIMESTAMP = ?
" with ParamValues: :p1='Ticket-SC-GER-20080214153230054', :p2='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 values.
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 <Olaf.Ohlenmacher@maxpert.de>
MaXpert AG, Berner Straße 119, 60437 Frankfurt am Main
Tel: +49 69 50065-265
Mobil: +49 172 6648 604
Thread Previous