Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
ORA-06508 on callback from DBMS_AQ.REGISTER

Hi:
We are using dbms_aq.register to register a Callback function to be called each time a message is enqueued in a queue. The callback function does not directly perform a dbms_aq.dequeue, instead we have a convenience package that does this, and we call this package from our callback function. This is working properly most of the time, except when we make any change in our convenience package. After compiling that package our callback process is fired but we get this error in the line where we call our convenience package: ORA-06508: PL/SQL: could not find program unit being called.
The occurrence of this error is not for each message that we enqueue, we get this error randomly, many times it get fires for each message during a time, other times it gets fired for some messages, but always after a time it disappears, the callback function works as expected and can call the convenience package without this problem.
We stop, delete, and recreate the queue each time we compile the package so, this couldn't be the source of this behaviour.
Our product version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production