Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL Callback Functions

601969Oct 7 2007 — edited Oct 11 2007
I've seen references to the PL/SQL callback procedure needed for a queue notification registration but I see not documentation to the actual structure of this callback procedure. For example, what are the required parameters and what do those parameters do?

Here is the object used for defining the callback in the DBMS_AQ.REGISTER call but I see no documenation reference to what that callback procedure signature needs to be (at least not in the 10.2 docs)

TYPE SYS.AQ$_REG_INFO IS OBJECT (
name VARCHAR2(128),
namespace NUMBER,
callback VARCHAR2(4000),
context RAW(2000),
qosflags NUMBER,
timeout NUMBER);

Also, what is the "context" attribute. As per the documentation, it is as follows:

context: Specifies the context that is to be passed to the callback function

Hmmmm...ok...any more detail would be greatly appreciated.

blake

Blake.Politte@sce.com
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2007
Added on Oct 7 2007
3 comments
2,721 views