-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|