Hi,

i'm having trouble trying to insert value into this table as shown below.

SQL> desc ordept
Name Null? Type
----------------------------------------- -------- ----------------------------
DEPTNO NOT NULL CHAR(3)
DEPTNAME NOT NULL VARCHAR2(36)
MGRNO REF OF EMP_T
ADMRDEPT REF OF DEPT_T

SQL>

SQL> insert into ordept values
2 ('A00','SPIFFY COMPUTER SERVICE DIV.','000010','A00');
('A00','SPIFFY COMPUTER SERVICE DIV.','000010','A00')
*
ERROR at line 2:
ORA-00932: inconsistent datatypes: expected REF got CHAR

How can i fix this.

Any help would be grateful.

Matt