I’m retrieving data with Perl from test files and sending that data into the Oracle tables. To send data I use SQL scripts written in the Perl program. It all works up to the moment I’m trying to assign to the variables Large Objects (like files or big characters). When the size of the value I’m assigning to the variable reach more than 4000 bytes, that value does not appear in the Oracle table.
In Perl variable itself is taking that value (it can be checked by printing the variable). On the Oracle site Large Objects can be inserted (without using Perl program) either.
So, something does not let to transfer the variable with value more than 4000 bytes from Perl site to the Oracle site. What and where should I do make it possible?
Thank you, Stanley