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 <[EMAIL PROTECTED]>
MaXpert AG, Berner Straße 119, 60437 Frankfurt am Main
Tel: +49 69 50065-265
Mobil: +49 172 6648 604
