Yup, you are right, you have to bind. No need for SQL TYPE though, just...
$sth->execute($foo, $bar); and you are done. For retrieving *LOB fields, you'll need to set LongReadLen and LongTruncOk Ilya Sterin P.S. All this info is in the FAQ www.xmlproj.com/cgi/fom.cgi -----Original Message----- From: Wysocki, James (J.D.) [mailto:jwysock3@;ford.com] Sent: Wednesday, November 13, 2002 10:15 AM To: '[EMAIL PROTECTED]' Subject: Problem inserting into a CLOB Hi, I'm having a problem inserting a row into my database with a CLOB column. My database version is Oracle 8.1.7. I can get it to work as long as my CLOB contains < 4948 bytes. However, if it is >= 4948, I get an Oracle error ORA-03113 "end-of-file on communication channel". I'm using the following statement to bind my variable to my insert statement: $sth->bind_param(2, $file_text); I have the feeling that I should be doing something like "$sth->bind_param(2, $file_text, {TYPE=>SQL_???? );" but I can't find the correct TYPE. The DBI module I'm using (version 0.90 I think) only has the following sql_types defined: SQL_CHAR=1 SQL_NUMERIC=2 SQL_DECIMAL=3 SQL_INTEGER=4 SQL_SMALLINT=5 SQL_FLOAT=6 SQL_REAL=7 SQL_DOUBLE=8 SQL_VARCHAR=12 I'm fairly new to Perl...is this a simple case of having an outdated version of the DBI module? Regards, Jim Wysocki [EMAIL PROTECTED]
