How to insert a file into a CLOB object?

[vel4ever]

I am using DBI to insert few records into Oracle database. I have a column in the table which holds CLOB data type. I have the data to be inserted in a flat file (.txt,.xml). How to prepare the insert statement for this and execute?

[kennethk]

See Simple_Usage in DBD::Oracle. From the link:

$sth->bind_param($field_num, $lob_value, { ora_type => ORA_CLOB });

after

use DBD::Oracle qw(:ora_types);

to import ORA_CLOB. There seems to be some conflicting data with regards to using SQLT_CHR instead, but I've successfully used the above.

[daxim]

What do the data look like? If they are encoded like I think they are, simply:

use File::Slurp qw(read_file);
my $lob = read_file 'data.txt', { binmode => ':raw' };