DROP TYPE ERROEXPEDICAO_TABLE
/

DROP TYPE ERROEXPEDICAO_TYPE
/

CREATE TYPE ERROEXPEDICAO_TYPE AS
OBJECT (CDFILIAL VARCHAR2(04),
NRPEDIDO VARCHAR2(10),
NRITEMPED VARCHAR2(10),
DSPRODUTO VARCHAR2(200),
DSERRO VARCHAR2(200));
/

CREATE TYPE ERROEXPEDICAO_TABLE AS
TABLE OF ERROEXPEDICAO_TYPE
/