By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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 220.127.116.11.
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.