0 Replies Latest reply on May 10, 2005 3:44 AM by 422716

    OJMS

    422716
      Hi,

      Published the messages into Multi-Consumer queue, the payload as SYS.AQ$_JMS_OBJECT_MESSAGE through Oracle JMS Interface to AQ api.

      The following is the desc of SYS.AQ$_JMS_OBJECT_MESSAGE

      SQL> desc SYS.AQ$_JMS_OBJECT_MESSAGE;
      Name Null? Type
      -------------- -------- ----------------------------
      HEADER AQ$_JMS_HEADER
      BYTES_LEN NUMBER(38)
      BYTES_RAW RAW(2000)
      BYTES_LOB BLOB

      As per my current understanding the object data will be stored in BYTES_LOB column which of BLOB type.

      I tried to query the data using the following script.
      ---
      declare
      l_lob blob;
      l_amt number default 30;
      l_off number default 1;
      l_raw raw(4096);
      begin
      select a.user_data.bytes_lob into l_lob from multi_message_table a where rownum=1;

      begin
      loop
      dbms_lob.read( l_lob, l_amt, l_off, l_raw );

      dbms_output.put_line('Data: ' || l_raw);
      l_off := l_off+l_amt;
      l_amt := 4096;
      end loop;
      exception
      when no_data_found then
      dbms_output.put_line('No Data. ');
      end;
      end;
      /
      ---

      It gave 'No Data' as output.

      I would like to know whether the object data stores in BYTES_LOB column ?.

      Any help on this ?.

      Thanks in advance.

      Regards,
      Murali.