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
Raoul
Messages: 20
Registered: April 2005
Junior Member
Hi

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.

Thanks
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
Liza79
Messages: 74
Registered: September 2006
Member
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?
Liza
Re: Insert into long raw field [message #192473 is a reply to message #192437] Tue, 12 September 2006 09:22 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have a look here

http://www.dbasupport.com/forums/showthread.php?s=&postid=209514

You might wanna read this as well

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:588223421081

[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: Tue Dec 06 04:10:19 CST 2016

Total time taken to generate the page: 0.20233 seconds