0
My situation is as follows, I have 2 tables with different Owners,
a stores the photos of the company’s employees in formed LONG RAW
and on the other site I need to fetch these photos and present them on the screen as an image but for this to happen it needs to be in BLOB because the table is like this;
I tried using the function TO_BLOB() but it doesn’t work.
When trying to make the conversion using the TO_BLOB()
I get the following error ORA-00932: inconsistent datatypes: expected BINARY got LONG BINARY
I have tried to create an intermediate table as seen in other questions but returns me error too
You could add the DDL of the tables (only the essential to reproduce the problem) and explain what you tried to do, with a brief explanation of what you tried along with the code?
– Danizavtz
Long Raw has been discontinued , the ideal would be to convert even to blog , vi este asktom , but as all asktom is too long for quick reading https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:510622111991
– Motta
tried the
TO_LOB?– Ricardo Pontual