How to insert large character strings in Perl+DBI?

Dear All,

I use perl script plus DBD for Oracle package to insert string which length is
> 4000 character (The data type is long in Oracle) and got th error message
"Error in preparing info from database sthORA-01704: string literal too long
(DBD ERROR: OCIStmtExecute)
DBD::Oracle::st execute failed: ORA-01704: string literal too long (DBD ERROR:
OCIStmtExecute) at ./cloning.pl line 13".   I know I can use bind variable in PL/SQL to fix the problem. but our application is made by perl. How can I do in perl? Another question is that, if we define BLOB datatype in Oracle db, how can we "SELECT/UPDATE/INSERT" in perl script?
Thanks.
Meng Received on Mon Oct 29 2001 - 22:38:41 CET