empth_clob() for CLOB column in INSERT necessary ?

10gR2 EE (10.2.0.3.0)

Have a table with a CLOB column.

In my application,
I first INSERT and populate all OTHER columns with an INSERT INTO....SELECT... Later in the process I update the CLOB column like:

UPDATE t_table_with_xml
SET xml_clob = (SELECT .... FROM ....)
WHERE t_pk = :pk

I'm wondering, should I populate the CLOB column with empth_clob() in the INSERT...SELECT ?
Does it make any difference like more efficient ?

thanks Received on Mon Sep 10 2007 - 11:17:26 CDT