 ORA-00997 : illegal use of LONG datatype [message #211368] |
Thu, 28 December 2006 03:59  |
 |
azamkhan
Messages: 557
Registered: August 2005
|
Senior Member |
|
|
I have 2 tables with same structure for example table emp1 and emp2. The tables have a LONG RAW column. Now through Developer 6i I am trying to insert the record from emp1 to emp2 by INSERT SELECT statement. Like this
INSERT INTO emp2 (ename, sal, emp_pict)
SELECT ename, sal, emp_pict FROM emp1
WHERE emp_no = :Emp1.empno;
The problem is that as this statement is executed it shows the following error on developer 6i:
Raised unhandled exception ORA-00997
I did tried Clob but it is not storing data for retiving from the database. I am using Developer 6i version 6.0.8.8.0 and Oracle 9i. Somebody told me that this problem is of developer 6i version 6.0.8.8.0. The higher version of 6i doesn't do this.
I believe that a good program doesn't has the word impossible in his/her dictionary... So I am hopping that there must be a way to do this. Please If any body could help me I would be very helpful to him/her. Reply me as soon as possible.
Regards,
Azam Khan
[Updated on: Thu, 28 December 2006 04:04] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
