| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: problem with trigger
hi,
Would like to know the trigger code.. to suggest soln.
Ts,
Raji
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of satish
plakote
Sent: Monday, October 09, 2000 10:46 AM
To: Multiple recipients of list ORACLE-L
Subject: 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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: satish plakote
INET: satish_plakote_at_excite.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.173 / Virus Database: 84 - Release Date: 7/19/00
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.173 / Virus Database: 84 - Release Date: 7/19/00
Received on Mon Oct 09 2000 - 01:26:29 CDT
 |
 |