RE: problem with trigger

From: Dan Johnson <daniel.johnson.1_at_wcom.com>
Date: Mon, 09 Oct 2000 09:40:15 -0500
Message-Id: <10644.118791@fatcity.com>

try show errors trigger trigger_name
it will show you the errors
dan

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Suri, Deepak
Sent: Monday, October 09, 2000 10:06 AM
To: Multiple recipients of list ORACLE-L Subject: RE: problem with trigger

You will not be able to see a trigger's compilation using show error. Do a select on the view user_errors or all_errors with the proper parameters.

thanx
deepak

-----Original Message-----

Sent: Monday, October 09, 2000 5:22 AM
To: Multiple recipients of list ORACLE-L

Satish,

After creating the trigger fire the following command to see what error exactly is:

SQL> show error

After that it will give the list of errors in the trigger code ...Then by looking at the code

and error listing anybody can help you !

Rgds-S

satish plakote <satish_plakote_at_excite.com> on 09/10/2000 10:45:54 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Sanjeev Sachdeva/PLs/TCSDELHI/TCS)

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

--

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 Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: 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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sanjeev Sachdeva
INET: sanjeevs_at_delhi.tcs.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message