Home » Developer & Programmer » Forms » ORA-00997 : illegal use of LONG datatype
icon9.gif  ORA-00997 : illegal use of LONG datatype [message #211368] Thu, 28 December 2006 03:59 Go to next message
Messages: 551
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 and Oracle 9i. Somebody told me that this problem is of developer 6i version 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.

Azam Khan

[Updated on: Thu, 28 December 2006 04:04]

Report message to a moderator

Re: ORA-00997 : illegal use of LONG datatype [message #212207 is a reply to message #211368] Thu, 04 January 2007 04:28 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Insert the non-long fields and then use and update statement to populate the long field.

I believe that no version of Oracle supports insertions of long fields.

Previous Topic: Drop Down Lists.
Next Topic: Problem with CREATE_OLEOBJ..
Goto Forum:

Current Time: Tue Jun 27 16:04:30 CDT 2017

Total time taken to generate the page: 0.09310 seconds