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

    Advanced Queues - can an array be a payload?

      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;

      queue_table => 'fruit_queue_tab',
      queue_payload_type => 'fruit_type_array',
      multiple_consumers => TRUE,
      comment => 'Queue Table For fruit Messages');

      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?