>I want to pass arguments to the procedure which is being called in the trigger .
This is not a Forms question really, but should be asked in the pl/sql forum.
Anyway, this is the normal format:
my_procedure (:new.pk_column, :new.other_column);
Thanks for your reply dude i had tried that way also when I'm trying to run the trigger for the first time in Oracle 11g it is considering :new as run time values and it prompts me to enter the value. The reason behind posting it in forms section because the records were updated or inserted into the backed from forms
1 person found this helpful
>Oracle 11g it is considering :new as run time values and it prompts me to enter the value
If you create your trigger with a script that you run in SQLPlus, you need to use "set scan off" first.
SQL> set scan off
("set scan off" is actually obsolete, but I still use it out of habit. You can use "set define" instead. See the sqlplus documentation).
Thanks for your reply that ahs worked when i m trying to exceute teh procedure as a single one it is working fine . But when i m calling it with forms i m getting an error
> But when i m calling it with forms i m getting an error
You cannot call a database trigger from forms. A trigger is part of the table, e.g.:
create trigger my_trigger
before insert or update or delete on my_table
for each row