Can you give me what the table schema is?
I would like to know what datatypes
col1,col2,col3,col4
are so I can try and recreate the error.
As well what operation system are you using and which version of DBI?
anyway just looking at the SQL it doesn't look quite right
cheers
John Scoles
[EMAIL PROTECTED] wrote:
Hello all,
I encouter an error with DBD::Oracle and Oracle instances 10g that I
dont understand :
DBD::Oracle::st execute failed: ORA-01008: not all variables bound
(DBD ERROR: OCIStmtExecute)
This script works fine with Oracle 9i.
I compiled DBD::Oracle (1.19) based on Oracle 9i (on Sun-Solaris10) -
DBI 1.58
I tried to compile DBD::Oracle (1.21) based on Oracle 10g (on
Sun-Solaris10) with the same error.
I tried to use DBI_TRACE=2 or 3 but I dont find the trace usefull.
My tests against Oracle instances :
9i (new install) - ok (it is always ok with 9i)
10g (new install) - bad
10g (migrated from 9i) - bad
My tests against placeholders :
If I used placeholders like ":param1", it works the first time, then
it will failed in general
My tests against the SQL query :
If I comment the first column returned (the TO_CHAR(...) AS DT, it
works the first time
then it failed
So the problem seems to be with CACHE or something like that ?
My script is :
#
------------------------------------------------------------------------
use DBI;
$dsn="dbi:Oracle:host=my_server;port=1521;sid=my_sid";
my $query = "
SELECT
TO_CHAR(TO_DATE(col1,'DD/MM/YY'),'YYYYMMDD') AS DT,
col2,col3,col4 FROM table1 WHERE SUBSTR(col1,4) = ?
";
$DBH = DBI->connect($dsn,"toto","toto",{PrintError => 0, RaiseError =>
1});
$STH = $DBH -> prepare($extraction_query);
my $month_MMAA="03/08";
#$STH->bind_param(":pr1", $month_MMAA);
$STH->bind_param(1, $month_MMAA);
$STH->execute();
DBI::dump_results($STH);
$STH->finish();
$DBH->disconnect();
#
------------------------------------------------------------------------
I need your help
Regards
Pascal
