Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> problem with trigger
hi ,
i am doinga project in java and oracle. I am using a set of tables . There r
some tables like Employee master,in which i want to have employee code
generated by sequences.
I am aming to have a dynamic Java code , where in any table ccan be selected
for an insert valeues option.
I want to write a trigger on the database side such that when ever i give an
insert query from my java code, the trigger should automatically insert the
employee code.
i tried writing a trigger but i got a message" triger created with
compilation errors"
Can somebody tell me how to write that trigger.and what should mt insert
statement be.Since i am declaring my primary ky as not null.
Thanks
satish