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

<*> 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/