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!

CLOB DATA TYPE INTO VARCHAR2

user2040934Sep 25 2012 — edited Oct 10 2012

Hi All

I have a table with a CLOB Column (SENDER_COMMENTS). A trigger is associated with that table, which sends email on insertion and updation.
I have used
EMAIL_BODY := DBMS_LOB.SUBSTR(:NEW.SENDER_COMMENTS,4000,1); In Trigger to pick this column data into a Varchar2 variable (EMAIL_BODY).

At Insertion time, It sends blank/null value, whereas at Updation time it sends proper value.
Please guide where I am doing wrong?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2012

Added on Sep 25 2012

#data, #database, #plsql, #sql, #trigger

20 comments

529 views