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]
