Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> problem with trigger

problem with trigger

From: satish plakote <satish_plakote_at_excite.com>
Date: Sun, 8 Oct 2000 21:10:30 -0700 (PDT)
Message-Id: <10643.118745@fatcity.com>


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



Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html Received on Sun Oct 08 2000 - 23:10:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US