OraFAQ Forum: SQL & PL/SQL » unable to delete record

Home » SQL & PL/SQL » SQL & PL/SQL » unable to delete record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to delete record [message #37560]

Thu, 14 February 2002 02:17

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.

Report message to a moderator

Re: unable to delete record [message #37563 is a reply to message #37560]

Thu, 14 February 2002 03:36

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

Report message to a moderator

Previous Topic:	Re: Explain plan
Next Topic:	help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 17 19:32:28 CDT 2025