Re: Oracle error PLS-00905 invalid object

From: Alex Paris <alessandro.paris_at_icc.it>
Date: 31 May 2004 00:49:33 -0700
Message-ID: <541f2359.0405302349.3b04e2e5@posting.google.com>

I solved my problem.
The error was here:

---

CREATE OR REPLACE TYPE TP_DBG_ART_SPEC AS OBJECT (  ID RO_ATTR_ART_SPEC.ID%TYPE,
 COD_SPEC RO_ATTR_ART_SPEC.COD_SPEC%TYPE,  DESCR RO_TB_ATTREZ_SPEC.DESCRIZIONE%TYPE,  ID_FIELD RO_ATTR_ART_SPEC.ID_FIELD%TYPE,

 SPEC_DESCR RO_ATTR_FIELD.DESCR%TYPE,
 VALORE RO_STO_ART_SPEC.VALORE%TYPE,
 F_TIPO RO_STO_ART_SPEC.F_TIPO%TYPE,

 SEQ_PRESENTAZ RO_STO_ART_SPEC.SEQ_PRESENTAZ%TYPE);
/

Correct declaration:

---

CREATE OR REPLACE TYPE TP_DBG_ART_SPEC AS object (

	ID		NUMBER(8),
	COD_SPEC	CHAR(10),
	DESCR		VARCHAR2(50),
	ID_FIELD	NUMBER(8),
	SPEC_DESCR	VARCHAR2(50),
	VALORE	VARCHAR2(500),
	F_TIPO	NUMBER(2),
	SEQ_PRESENTAZ	NUMBER(2));

/

Thanks all.
I hope this can help others.
Bye. Received on Mon May 31 2004 - 02:49:33 CDT