Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql - lost variable value
"Alex" <adurrant_at_hatch.ca> wrote in message
news:1147806547.048536.124280_at_g10g2000cwb.googlegroups.com...
> 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.
>
If the function isn't too big, post it and an example of usage, and I'll take a look at it.
BTW, what version of Oracle is being run, and on what platform?
-- Andreas Sheriff Oracle 9i Certified Professional Oracle 10g Certified Professional Oracle 9i Certified PL/SQL Developer ---- "If you don't eat your meat, you cannot have any pudding. "How can you have any pudding, if you don't eat your meat?" DO NOT REPLY TO THIS EMAIL Reply only to the group.Received on Tue May 16 2006 - 22:37:07 CDT