Home » SQL & PL/SQL » SQL & PL/SQL » unable to delete record
unable to delete record [message #37560] Thu, 14 February 2002 02:17 Go to next message
ranjan kumar dash
Messages: 15
Registered: February 2002
Junior Member
I have created a trigger and try to delete from the emp table it is not allowing me to delete but after i drop the trigger by giving command
SQL>drop trigger

trigger dropped sucessfully then again i tried to delete one record but i am not able to delete a single record.
Re: unable to delete record [message #37563 is a reply to message #37560] Thu, 14 February 2002 03:36 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
i recokn another trigger is there for emp table, which is 'SCOTT.TRIG_DELETE' and it is not the trigger i have given u. can u drop it and try deleting again
Previous Topic: Re: Explain plan
Next Topic: help
Goto Forum:
  


Current Time: Fri Sep 24 16:20:26 CDT 2021