3 Replies Latest reply: Sep 21, 2012 11:04 AM by Newton's Apple RSS

    must specify table name for nested table column or attribute

    praveen435
      Hi,
      I got stuck when using Table of in creating queues.

      My scenario is

      CREATE or Replace TYPE address_t AS OBJECT (
      street VARCHAR2(30),
      city VARCHAR2(20),
      state CHAR(2),
      zip CHAR(5) );

      CREATE TYPE address_tab AS TABLE OF address_t;

      CREATE or replace Type customers AS OBJECT(
      custid NUMBER,
      address address_tab );

      BEGIN
      DBMS_AQADM.CREATE_QUEUE_TABLE (
      queue_table => 'aq_user.Order_qts'
      , queue_payload_type => 'aq_user.customers'
      );
      end;

      I end up with the below error
      ORA-22913: must specify table name for nested table column or attribute

      then i used nested table command and tried as below:

      CREATE TYPE customers AS Object (
      custid NUMBER,
      address address_tab )
      NESTED TABLE address STORE AS customer_addresses;

      then i faced an error as below:

      ORA-06545: PL/SQL: compilation error - compilation aborted
      ORA-06550: line 0, column 0:
      PLS-00565: customers must be completed as a potential REF target (object type)


      so any suggestions would be great.

      Thanks.

      Regards,
      Praveen