Home » Server Options » Streams & AQ » Function after dequeing (9i)
Function after dequeing [message #334004] Tue, 15 July 2008 03:11 Go to next message
Messages: 13
Registered: June 2008
Junior Member

I use AQ in my work in which I dequeue near 1 100 thousand XML's
I use insert procedure within my dequeue procedure means

        queue_name         => 'XYZ',
        dequeue_options    => dequeue_options,
        message_properties => message_properties,
        payload            => message,
        msgid              => message_handle);
   /* Procedure INSERT invoked to insert data  */

       dequeue_options.navigation := DBMS_AQ.NEXT_MESSAGE;

I perform XML operations only after dequeue is over and all data is loaded by insertdat procedure

Now There is req that the same queue will contain three diff types of XML's and I need to use three diff procedures to insert in three diff tables....
Can anyone suggest which function can i use to identify the type of XML(read the tag from p2 before inserting) which is p2 in the code...I will use if statement and based on that tag i will call any of three procedures....

please suggest ...

thanks a lot
Re: Function after dequeing [message #334121 is a reply to message #334004] Tue, 15 July 2008 08:35 Go to previous message
Messages: 13
Registered: June 2008
Junior Member
Anyone please help...

Previous Topic: Problems on Oracle Streams AQ Examples
Next Topic: Single instance of Callback procedures
Goto Forum:

Current Time: Sun May 26 19:51:45 CDT 2024