Home » SQL & PL/SQL » SQL & PL/SQL » Executing a trigger
Executing a trigger [message #238170] Wed, 16 May 2007 23:22 Go to next message
apps_ara
Messages: 29
Registered: January 2007
Location: Pune
Junior Member
I have a trigger which has to be modified on a base table. I dont have access to my base table, but i need to check whether my trigger is working properly or not. how can i check it?? is there any way to execute and know how my trigger fires?? please let me know

thanx in advance

priya
Re: Executing a trigger [message #238171 is a reply to message #238170] Wed, 16 May 2007 23:46 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>I have a trigger which has to be modified on a base table. I dont have access to my base table, but i need to check whether my trigger is working properly or not.
>how can i check it?? is there any way to execute and know how my trigger fires?? please let me know
It is called a TEST or QA database against which new code is executed before deploying into Production.
Re: Executing a trigger [message #238174 is a reply to message #238171] Thu, 17 May 2007 00:08 Go to previous messageGo to next message
apps_ara
Messages: 29
Registered: January 2007
Location: Pune
Junior Member
base table is in prod instance,,and we are in dev instance
Re: Executing a trigger [message #238176 is a reply to message #238170] Thu, 17 May 2007 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>base table is in prod instance,,and we are in dev instance
Are you claiming that the dev instance has a DIFFERENT structure than Production?
A TRIGGER matters on table structure & trigger logic NOT volume of data.
So explain again why trigger can NOT be tested in DEV/QA.
Re: Executing a trigger [message #238179 is a reply to message #238176] Thu, 17 May 2007 00:25 Go to previous messageGo to next message
apps_ara
Messages: 29
Registered: January 2007
Location: Pune
Junior Member
assume that you dont have access to any base tables. I just want to know how do u check a trigger before we try to fire it on any table. Dont make this complicated.
Re: Executing a trigger [message #238184 is a reply to message #238170] Thu, 17 May 2007 00:57 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Dont make this complicated.
Not complicated for me.
I'd test code.
Since I don't have YOUR problem, You're On Your Own (YOYO)!
Re: Executing a trigger [message #238201 is a reply to message #238184] Thu, 17 May 2007 01:42 Go to previous messageGo to next message
apps_ara
Messages: 29
Registered: January 2007
Location: Pune
Junior Member
its better having a problem rather than getting complicated. Cool

anyways thanx for your help thou
Re: Executing a trigger [message #238246 is a reply to message #238201] Thu, 17 May 2007 03:19 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Surely even a complicated solution is better than having a problem.

You could try setting Tracing on for a session and looking through the dump file for any SQL contained in the trigger.

If the trigger is valid and enabled, then it will be being executed. Do you have any reason to believe that this isn't the case.
Re: Executing a trigger [message #238362 is a reply to message #238246] Thu, 17 May 2007 10:56 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Or, if this trigger code is so complicated, abstract it from the trigger into a stored procedure.
This can be called quite easily. Only thing left to test is to see if the right parameters are provided.

[Updated on: Thu, 17 May 2007 10:57]

Report message to a moderator

Previous Topic: Error occured while compiling
Next Topic: Local Partitioned Index Status
Goto Forum:
  


Current Time: Sun Dec 04 13:07:09 CST 2016

Total time taken to generate the page: 0.10334 seconds