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.


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