By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jul 19 '05 #2

P: n/a
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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.