Problem solve
Get help with specific problems with your technologies, process and projects.
Extracting from LONG datatype column
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?
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
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 9.2.0.4.
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.
