This is happening on a Oracle 11g R2 database.
I have two schemas one that contains code and one that contains data.
Lets call them CODE_SCH and DATA_SCH.
I have package PKG1 in the code schema with AUTHID CURRENT_USER and they get called from DATA_SCH.
Here is the problem. When I connect to DATA_SCH and call a function in CODE_SCH, it runs fine. But after that if I make any update to the package in the code schema and compile it, I get a ORA-06508 error. There is no way to fix this without completely reconnecting to the schemas again (closing Toad and reopening). I thought its an issue with the code. But the same problem happens when I use SQL*Plus.
Not sure how much this matters but we use VPD in the DATA_SCH to segregate information and a context setting call is done after connecting to the schema to set which context data we want the code to see.
I'm unable to figure out what is going on here.
Can anyone provide any leads?
I can post more information if necessary.
Thanks!
Arijit