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.
Previous Topic: View with MAX( DECODE( returns no rows, 9iDS
Next Topic: Display User Name
Goto Forum:
  


Current Time: Thu Mar 28 03:09:29 CDT 2024