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

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

LOOP
       BEGIN
       DBMS_AQ.DEQUEUE(
        queue_name         => 'XYZ',
        dequeue_options    => dequeue_options,
        message_properties => message_properties,
        payload            => message,
        msgid              => message_handle);
   /* Procedure INSERT invoked to insert data  */
       INSERTDAT(message.p1,message.p2);

       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
kumar1234
Messages: 13
Registered: June 2008
Junior Member
Anyone please help...

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


Current Time: Sun Dec 08 05:25:49 CST 2024