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? My Oracle version is 9.2.0.4.

    Requires Free Membership to View

    Login

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.

This was first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top