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

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/