troubleshooting Question

How do I properly execute a trigger using cursor query

Avatar of lulubell-b
lulubell-b asked on
Oracle DatabaseSQL
9 Comments1 Solution765 ViewsLast Modified:
Please find attached table structure and the trigger developed to update the stage table (s_ais) when changes occur to the underlying table, ais.  As we are only interested in a subset of records found in the ais table, I attempted to use a cursor to filter only on ais that are of interest to CDT.  

My trigger is failing, ORA-06502; numeric or value error: char string buffer too small on line 40.  Yet I fail to see the necessary action to be taken.  I assume the cause is that I am trying to execute a statement that resulted in an arithmetic, numeric, string, conversion, or constraint error.

If I run the cursor solo, the resultant is as expected.  A proper list of ais displays.

Any assistance is appreciated.

TableStructure.txt
S-U-AIS-ID-SEQ-TR-ExpHlp.txt
ASKER CERTIFIED SOLUTION
lulubell-b

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros