RE: Re: How to run a trigger in SB in Toad for Oracle?

This isn't in the SB, you have to do debugging from the editor.  From the SB, select the trigger, click Open In Editor.  From the editor, follow the directions in the Help file.

Greg

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of linorchid
Sent: Tuesday, March 19, 2013 7:47 PM
To: [email protected]
Subject: [toad] Re: How to run a trigger in SB in Toad for Oracle?

Thanks for the information about the help file on debugging triggers.  But after reading, I am still clueless as to how to set parameters and then run a trigger.

The help file mentions about setting the parameters for that trigger before running a trigger.  In the Set parameters section, the first step is:

1.	Click (...) on the Execute toolbar.
or
Select Debug | Set Parameters.

Where is the Execute toolbar while the Triggers tab is open in the SB?  

All options are gray out in the Debug menu including "(...)Set Parameters." 

I am using Toad for Oracle 11.5 & 11.0.  

Any advice, thoughts or suggestions?   Thanks.


--- In [email protected], Gregory Liss <gregory.liss@...> wrote:
>
> There is a section in the Help file on debugging triggers.  Just search for Triggers in the Index.
> 
> Greg
> 
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of linorchid
> Sent: Tuesday, March 19, 2013 2:51 PM
> To: [email protected]
> Subject: [toad] How to run a trigger in SB in Toad for Oracle?
> 
> Hello All,
> 
> Just a little background on why I have to run a trigger for troubleshooting:
> 
> A trigger is activated when a column of a table in our database is updated thru an Oracle form application.  This column is defined as NUMBER(9) in a database table.  But, I receive the following error message each time when I set the column to 100000000 or greater value:
> 
> ORA-06502: PL/SQL: numeric or value error:number precision too large ORA-06512:at "<Owner>.<Trigger>", line 194 ORA-04088: error during execution of trigger "<Owner>.<Trigger>"
> 
> Shouldn't the acceptable maximum value be 999999999 since the column attribute is defined as NUMBER(9)?  
> 
> So, I am in the process of troubleshooting the trigger and I need to know how to run a trigger manually in SB.  Alternatively, I could run the trigger by updating the database table by setting the value >= 100000000.  I just want to simplify the trouble shooting process so that I can concentrate and find the root cause the problem.  
> 
> Thanks all in advance!
> 
> 
> 
> 
> 
> ------------------------------------
> 
> Yahoo! Groups Links
>




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

Yahoo! Groups Links





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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/