I have a table with a column specified as the LONG datatype. When selecting data I get the following error: "ORA-00932: INCONSISTENT DATATYPE." Is there a quick way to extract this information? My Oracle version is 18.104.22.168.
You can try to explicitly convert the LONG datatype to a character datatype with the TO_CHAR function:
SELECT TO_CHAR(my_long_column) FROM my_table;
You can then store the returned value to a variable defined as the VARCHAR2 datatype.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.