Hi,
I ran into this once. Have you tried setting the LongReadLen parameter:
### We're not expecting binary data of more than 512 KB...
$dbh->{LongReadLen} = 512 * 1024;
Cheers,
Stacy.
________________________________________
From: Simran Saun [[email protected]]
Sent: Monday, 13 July 2009 9:45 PM
To: [email protected]
Subject: Exporting a clob data type
Hi All,
I need to export contents of a table whch has one data type as CLOB.
I am able to store it ina file using query, "select PROFILE_ID ||'#COL#'||
ADM_TYPE ||'#COL#'|| ACC_TYPE ||'#COL#'|| STATUS ||'#COL#'|| ACC1
||'#COL#'|| ACC2 ||'#COL#'|| OPAQUE_STRING ||'#ROW#' from PROFILE".
however, the data which is returned is restricted to 82 characters each
line.
Any means to increase the size ?
Regards,
Simran
