Hi,
Thanks for the reply.

All I need to be able to do here is to search for a particular key word and display all the records in the clob column which match the criteria and also it would be good if i am able to commit or rollback the transaction.

Please Suggest

Ronnie