Please direct questions like this to the DBI mail list.
If the statement works for most, but not all, data lines, try to discover
which data triggers the problem. You should be able to write the data to a
debug file while troubleshooting. If you write both the error messages and
the data to the file, you should be able to see which data line has the
problem.
Without seeing an actual example that causes the problem, it would be
difficult to say more.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Alexander Knack" <[EMAIL PROTECTED]>
To: "Tim Bunce" <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 10:19
Subject: DBD::Oracle: two-task internal error
> i have some DBD::Oracle errormessage, i cant' figure out what it could
> mean:
> DBD::Oracle::st execute failed: ORA-03124: two-task internal error (DBD
ERROR: OCIStmtExecute) at export_from_mysql.pl line 188.
> ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) at
export_from_mysql.pl line 188.
>
>
> i'm doing some
> $sth = $dbh->prepare ("insert into table(a,b,c) values (?,?,?)");
> $sth->execute (1,2,3);
>
> unfortunately the table has 63 columns and the prepare and
> execute statements don't look nice.
> i'm importing the data for the inserts from an other database (mysql)
> and for the most values the insert works. so i don't know
> where to start searching for invalid input.