inserting values into REF datatypes
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