OraFAQ Forum: SQL & PL/SQL » Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error.

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. (Oracle 11g : bug)

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

Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. [message #640065]

Tue, 21 July 2015 12:44

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

Create or replace trigger test1
after insert or update
On test1
For each row
Begin
Insert into testhist
Values (:new.empid);
End difftest;

Report message to a moderator

Re: Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. [message #640069 is a reply to message #640065]

Tue, 21 July 2015 14:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use [code] tags and make your code easier to read

post URL where it is written that END label is required & must be the same as trigger_name.

Report message to a moderator

Re: Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. [message #640070 is a reply to message #640065]

Tue, 21 July 2015 14:20

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If this is true then it is a bug and then? What so you expect from us?

Report message to a moderator

Re: Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. [message #640072 is a reply to message #640070]

Tue, 21 July 2015 14:26

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Sorry, I stand corrected, this is not a bug, trigger body is just a PL/SQL block and in this case "name" after final "end" is just a comment.

The documentation states:

Quote:

The name of the block to which END applies--a label, function_name, procedure_name, or package_name.

So the constraint does not apply to trigger.

Edit: I now know what you expect from us: you expect we search in the documentation for you. Razz

[Edit: add link to doc]

[Updated on: Tue, 21 July 2015 14:33]

Report message to a moderator

Re: Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. [message #640076 is a reply to message #640072]

Tue, 21 July 2015 14:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Edit: I now know what you expect from us: you expect we search in the documentation for you.
which you do with regularity & alacrity.

Report message to a moderator

Re: Oracle trigger name and after end of the trigger name if mismatch, trigger is compiled and no error. [message #640096 is a reply to message #640076]

Wed, 22 July 2015 05:01

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

Report message to a moderator

Previous Topic:	all_scheduler_job_run_details session_id column
Next Topic:	Covert unique string to unique number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:30:06 CDT 2024