| Clob from Perl [message #97680] |
Thu, 07 November 2002 12:59  |
Mery Orellana
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
I have a stored procedure where there are any clob's types in input and output parameters, I need to read and extract this clob's parameters from a script Perl, How can I do that?
Thank you by any idea.
|
|
|
|
|
|
| Re: Clob from Perl [message #97928 is a reply to message #97698] |
Tue, 17 June 2003 13:09  |
Sangeeta Santani
Messages: 1
Registered: June 2003
|
Junior Member |
|
|
Hi,
I am inserting a text file into a clob column of the Oracle DB. The program runs successfuly but when the clob column is selected from the table, it shows only part of the text file. The LongReadLen =512*1024. I tried changing it's values to 10000*1024. But still I got the same output.
Also I tried to select the inserted record and append it to a new textfile. I always get the size of the new textfiel created which is 0 byts.
Could you please tell me why the insert ito clob column truncateds the value. And why I am not getting the truncated column value back in the next select?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
