Creating trigger in oracle

Question

create or replace trigger insert_catid
before  insert or update or delete on categories
for each row
begin
SELECT categories_seq.NEXTVAL INTO :NEW."cat_uid" FROM DUAL;
end;

i am using oracle 11g. I am compiling this trigger it is giving me error of

Error(7,36): PLS-00049: bad bind variable 'NEW.cat_uid'

please suggest me about this error

Tony Andrews · Accepted Answer · 2011-05-12 16:04:41Z

2

It means there is no column "cat_uid" in the table. By putting the name inside double quotes you have made it case-sensitive, so if your column is actually CAT_UID this will not work, i.e. you need to remove the quotes.

answered May 12, 2011 at 16:04

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating trigger in oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related