How to create a Registration vector in PLSQL

0

I have a record of

    TYPE trec IS RECORD ( 
        cd_multi_empresa NUMBER(8,2),
        tp_atendimento   CHAR(2)
      );

vcAtendimento trec;

I need a registry vector, I used this and command:

TYPE TcAtendimento IS VARRAY(10) OF vcAtendimento;
  

At the end I get an error message: Error Reporting - ORA-06550:   line 8, column 39: PLS-00488: 'VCATENDIMENTO' must be a type   ORA-06550: line 8, column 1: PL / SQL: Item ignored ORA-06550: line   13, column 41: PLS-00321: expression 'TcAttention' is   inappropriate as the left hand side of an assignment statement   ORA-06550: line 13, column 5: PL / SQL: Statement ignored   06550. 00000 - "line% s, column% s: \ n% s"   * Cause: Usually a PL / SQL compilation error.   * Action:

    
asked by anonymous 10.05.2018 / 23:24

1 answer

0

After reading the PLSQL oracle documentation:

TYPE TcAtendimento IS VARRAY(10) OF trec;
    
14.05.2018 / 20:00