Home » Developer & Programmer » Forms » trigger to call sequence on his primary key column
trigger to call sequence on his primary key column [message #84056] Thu, 22 January 2004 09:42
Dawar
Messages: 6
Registered: January 2004
Junior Member
I have a table called xyz.

I like to put trigger to call sequence on his primary key column.

I already created sequence.

Now I need to generate sequence number on Primary Key column.

create trigger xyz_t

after

update on table_name

for each row

begin

insert into item values

(select seqnname_SEQ.nextval from dual);

end;

It is showing me invalid status.

Any feed back will be appreciatyed.

Report message to a moderator

Previous Topic: View with MAX( DECODE( returns no rows, 9iDS
Next Topic: Display User Name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Oct 28 06:42:28 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.