Home » SQL & PL/SQL » SQL & PL/SQL » Insert into long raw field
Insert into long raw field [message #192432] Tue, 12 September 2006 06:28 Go to next message
Messages: 20
Registered: April 2005
Junior Member

I have a question regarding the insertion of long raw data into a table. I have already made a serch in the forum but no success. This is the query that I am trying to run:

Insert into table1 (select * from table2 where fieldX='some value')

I am getting error: "ORA-00977 illegal use of long datatype" because one of the fields in the tables is of Long Raw type.

Any suggestions would be greatly appreciated.

Re: Insert into long raw field [message #192437 is a reply to message #192432] Tue, 12 September 2006 06:39 Go to previous messageGo to next message
Messages: 74
Registered: September 2006
i don't think the long raw can be manipulated in this fashion, in PL/SQL or SQL.

What i do is i always put data into a long raw through my applications. Off course thats what long raw is there for, showing binary contents to applications.

I am not sure, Any one who can comment otherwise?
Re: Insert into long raw field [message #192473 is a reply to message #192437] Tue, 12 September 2006 09:22 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have a look here


You might wanna read this as well


[Updated on: Tue, 12 September 2006 09:28]

Report message to a moderator

Previous Topic: Truncate trailing spaces on select
Next Topic: debug
Goto Forum:

Current Time: Mon Oct 24 03:57:32 CDT 2016

Total time taken to generate the page: 0.07609 seconds