Home » Infrastructure » Unix » Clob from Perl
Clob from Perl [message #97680] Thu, 07 November 2002 12:59 Go to next message
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 #97698 is a reply to message #97680] Mon, 18 November 2002 06:34 Go to previous messageGo to next message
Messages: 76
Registered: August 2002
use dbms_lob oracle procedure !!!
Re: Clob from Perl [message #97928 is a reply to message #97698] Tue, 17 June 2003 13:09 Go to previous message
Sangeeta Santani
Messages: 1
Registered: June 2003
Junior Member

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?
Previous Topic: Mailx
Next Topic: Oracle log real time monitoring
Goto Forum:

Current Time: Sun Oct 01 20:14:18 CDT 2023