I have searched high and low for an answer to this, can anyone help?

I am writing a BEFORE INSERT trigger on a table with a calumn called
COMMENTS which is of type CLOB. I need to assign a value (another CLOB
from a different table) to :new.COMMNETS - but I understand this is a
problem in Oracle 8.

There must be a way to do this. I am aware of DMBS_LOG but I can't
manage to get it working.

Does anyone have a solution?

whitegoose (AT) inorbit (DOT) com wrote:
1) Your Oracle version?
2) What is the problem in Oracle 8? Please be more specific and provide
an error message.
3) There isn't a dbms_log object. Do you mean dbms_logmnr package?

Regards
/Rauf

whitegoose (AT) inorbit (DOT) com wrote:
What version
What problem
What DDL
What DML
What does DBMS_LOG, which doesn't exist, have to do with anything?

PS: No column should ever be named COMMENTS. If it is, for example,
the person table, name the column PERSON_COMMENTS.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

The Version is 8.1.7

The problem is that Oracle 8 does not allow :NEW.XXXX to be updated
from a trigger where XXXX is a CLOB field.

My apologies, it was a typo - I meand DBMS_LOB - a package used for
mainpulating LOBs and CLOBs.

I can't provide DML and DDL because I'm not after a solution to a
specific problem, I just wanted to know if anyone had a solution for
updating CLOB fields from a trigger on the same table. (eg. Yes you can
do it - use DBMS_LOB.WRITE to update the field)

I do not have a choice about the name of the COMMENTS field.

Thanks,
Josh.

whitegoose (AT) inorbit (DOT) com wrote:
Which means it is really important to have a version of Oracle
that supports LOBs.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)