1 Reply Latest reply: Dec 19, 2011 1:42 PM by Tubby RSS

    Advanced Queues - can an array be a payload?

    905920
      Having trouble creating a queue with an array as payload:

      create or replace type fruit_type as object
      (
      fruit_id number(18),
      fruit_name varchar2(50),
      fruit_date date
      );

      create or replace type fruit_type_array as table of fruit_type;

      BEGIN
      DBMS_AQADM.create_queue_table(
      queue_table => 'fruit_queue_tab',
      queue_payload_type => 'fruit_type_array',
      multiple_consumers => TRUE,
      comment => 'Queue Table For fruit Messages');
      END;

      When I run the last statement, I get "ORA-22193 - must specify table name for nested table name or column". If I replace the 'fruit_type' for 'fruit_type_array' it works fine. Apparently, it doesn't like the array. Any ideas?

      Thanks.