How to create a Registry vector in PLSQL

Asked

Viewed 156 times

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;

In the end I get an error message: Bug report - ORA-06550: row 8, column 39: PLS-00488: 'VCCUSTOMER' must be a type ORA-06550: row 8, column 1: PL/SQL: Item Ignored ORA-06550: row 13, column 41: PLS-00321: Expression 'Tcatendimento ' is inappropriate as the left hand side of an assignment statement ORA-06550: row 13, column 5: PL/SQL: Statement Ignored 06550. 00000 - "line %s, column %s: n%s" *Cause: Usually a PL/SQL Compilation error. *Action:

  • TYPE Tcservice IS VARRAY(10) OF Trec ;

1 answer

0


After reading the oracle PLSQL documentation:

TYPE TcAtendimento IS VARRAY(10) OF trec;

Browser other questions tagged

You are not signed in. Login or sign up in order to post.