Somewhere in the manuals (possibly the
Pl/SQL supplied packages) I recall seeing
an explicit note to the effect that when you
use the dbms_lob package, triggers on the
table do not fire. Since MV logs are maintained
through triggers (albeit system internal ones)
this would explain one part of the problem if
my memory isn't playing tricks on me.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____England______September 24/26, November 12/14
____USA__________November 7/9 (MI), 19/21 (TX)
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Bradley Brown wrote in message ...
>Thanks for taking the time to answer
>
>I know that if I'm inserting less than 4,000 bytes I don't need to use the
>DBMS_LOB routines but at some point we may. After investigation of the logs
>I too concluded that something doesn't look right, however, I wasn't sure
if
>it was something wrong with my code or perhaps a bug. I looking for some
>sort of confirmation either way.
>
Received on Fri Sep 13 2002 - 05:21:17 CDT
