Are you sure what versions you have??
Richard Sutherland wrote:
> All,
>
> I am getting an ORA-01008 when using bind variables on Oracle7 instances,
> but not on Oracle8 instances. This has happened on both Unix and Linux
> OS's. Here is the error:
>
> DBD::Oracle::db prepare failed: ORA-01008: not all variables bound
> (DBD ERROR: OCIStmtExecute/Describe) at ddl_test.pl line 40, <STDIN>
> chunk 3.
>
> This was not happening with prior versions of DBD::Oracle (back with
> 1.06, I think).
>From your trace:
>
> DBI 1.08 dispatch trace level set to 3
> -> DBI->connect(dbi:Oracle:ci_tw1_tst, rsutherl, pebb3343, HASH(0x140002068))
> -> DBI->install_driver(Oracle) for perl=5.00404 pid=29011 ruid=217 euid=217
> install_driver: DBD::Oracle loaded (version 1.06)
Try upgrading to the current version of DBI/DBD::Oracle ....I am not sure of the
latest version, but I have DBI-1.18 and
DBD::Oracle 1.07.
perl -MDBD::Oracle -e 'print DBD::Oracle->VERSION'
perl -MDBD::Oracle -e 'print DBD::Oracle->VERSION'
cheers,
jeff
