Where should trigger for nextval on insert reside: in schema or in form? -

Where should trigger for nextval on insert reside: in schema or in form? -

i want insert record table (inkpen) via oracle form , want utilize trigger create next inkpen_id.

create trigger inkpen_trigger_1 before insert on inkpen each row begin select inpken_id.nextval :new.pen_id dual; end;

questions:

where should trigger reside: in schema or in form?

if part of schema can form phone call it?

i'm thinking should part of schema because may necessary insert record outside form , nextval logic in place.

my dba says need imbed trigger logic form.

i'm asking because don't have rights create trigger can test , dba hesitant create me.

for it's worth, here's fiddle trigger logic

you can set in pre-insert trigger of block table inkpen in form.

triggers insert oracle11g oracleforms