I made this change in a package (i.e. PL/SQL). I was changing so many modules yesterday, that I have forgotten which one this change was done to. But, I could not find a commit-type statement in PL/SQL. The only message I saw was "Package created".
I waited a while, made some other chages to some .tcl and it was still busted.
So this morning, I bounced Oracle, and the changes seemed to go thru. I will need to look into this further.
- Does the engine cache compiled packages?
- If so, what is the procedure to make new packages become "live"?
In the meantime, I will document the original problem I was trying to solve (wrt bboard subscription notifications).
Regards..Roger
