pl/sql - lost variable value

I'm having a problem that I'm hoping someone out there has experienced before and has a solution for.

I have a package that includes a function that is executed on an insert trigger. About 2/3 of the way through the function, the values of 3 variables are lost. i.e. all 3 variables "go to" null for no appparent reason. I checked, and there are no modifications being made to the variables. Also, I created a seperate package for the variables to access them there instead, they still "go to" null. So the procedure parameters, the local variables and the variables in a "repository" package all lose their values and end up being null. To furhter complicate the situation, this only happens when the process is run from a cursor. i.e. cursor of x number of parent records, results in x inserts into a table. After y inserts, (and y is always a different number after each attempt) the variables lose their values. (Hope that was understandable). Has anyone encountered this before? Is this a memory/tuning issue? What should I ask the DBA to look into?

The application is a large client/server app that has been in production for over 12 years. I am new to the team and we basically work on support and bug fixes/minor enhancements. My Oracle knowledge is limited and certainly does not cover anything beyond ER and general PL/SQL and SQL skills.

Any help you can offer would be fantastic. I am out of ideas. Thanks.
Alex. Received on Tue May 16 2006 - 14:09:07 CDT