Wrong no of type of arguments for field called 'keywords'

[Cherry]

I have a trigger that won't compile:

CREATE OR REPLACE TRIGGER TRG_CORRESPONDENCE_UPT
AFTER UPDATE
on TBLCORRESPONDENCE
for each row

BEGIN

IF :OLD.Keywords <> :NEW.Keywords THEN
spInsertAuditRecord_ins('tblCorrespondence',
'Keywords',
:OLD.CorrespondenceId,
:OLD.Keywords,
:NEW.Keywords,
SYSDATE,
:OLD.UpdatorId,
'U',
0);
END IF;
END TRG_CORRESPONDENCE_UPT;

/

I'm getting a 'wrong number of arguments or datatype' error message.
If I replace the reference to 'keywords' with any other column name or
literal, the trigger will compile. I cannot find any documentation in
Oracle that states that 'keywords' is itself a keyword. Anybody got
any ideas. You can respond to me directly at
ch***********@dhs.state.tx.us or to this post. Thanks.

[Cherry]

Thanks to Guy Quesnel for this - -

It seems that the problem is 1) the column is a CLOB in both tables
but the stored procedure that is called accepts a varchar2 as a
parameter. So, here's my next question---

Is there any way to perform a substring type function against a
CLOB???

Thanks.

You may respond to me at ch***********@dhs.state.tx.us or to this
post.

Cherry

[Hans Forbrich]

Cherry wrote:

Thanks to Guy Quesnel for this - -

It seems that the problem is 1) the column is a CLOB in both tables
but the stored procedure that is called accepts a varchar2 as a
parameter. So, here's my next question---

Is there any way to perform a substring type function against a
CLOB???

From the explanation of the SUBSTR function in the SQL Reference manual at
http://otn.oracle.com/pls/db92/db92.homepage

"string can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB,
or NCLOB. The return value is the same datatype as string. Floating-point
numbers passed as arguments to SUBSTR are automatically converted to
integers."

You might want to bookmark http://docs.oracle.com as many of these types of
questions are answered quickly from the online documentation.

/Hans