Inserting and retrieving CLOB object from the Oracle Database 1

[ktsrikanth]

Hi,

I want to know how to store and retrieve some articles in oracle’s CLOB datatype.
e.g. table : Article
columns : id number
: article clob
Please provide me the sample code or links where I can get additional info.

Thanks,
Srikanth

 

[hmerrill]

See the FAQ in this Perl forum - there is a FAQ on how to set up Perl to talk to a database. You'll need DBI and DBD::Oracle - and the perldocs that come with DBD::Oracle explain how to handle CLOB's - just do "perldoc DBD::Oracle" after you've installed DBD::Oracle.

HTH.
Hardy Merrill
Mission Critical Linux, Inc.

http://www.missioncriticallinux.com