| Insert into long raw field [message #192432] |
Tue, 12 September 2006 06:28  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
