Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using dbms_lob in trigger 10gR2

616017Mar 11 2008 — edited Mar 12 2008
Hello,

I'm trying to read from a clob using dbms_lob in my trigger and assigning the value to a variable. My trigger is compiling fine, but it doesn't seem to be working.
I'm using 10gR2. Am I misunderstanding how to read from/assign to a variable in a trigger?

Line from trigger code:
...
v_serial_start := dbms_lob.instr(:new.search_xml_clob,'serial=') + 8;
...

Thanks,
Mimi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2008
Added on Mar 11 2008
8 comments
727 views