ORA - 00932: data types inconsistent: should be -, but get a BLOB-CodePudding

ORA - 00932: data types inconsistent: should be -- but for BLOB does anyone know what's going on? Online etc.

CodePudding user response:

I this is stored images

CodePudding user response:

refer to the original poster zys_qyy response:

ORA - 00932: data types inconsistent: should be -- but for BLOB does anyone know what's going on? Online, such as

What is the SQL statement? Posted to see see!

CodePudding user response:

Clear specific scenarios, post your SQL

CodePudding user response:

Stick your SQL database field come out I have time is CLOB, but I use the case when the final conclusion should be VARCHAR2 is hint say a type of inconsistencies

CodePudding user response:

I met with wm_concat connection, the content is too long, also prompt the error

CodePudding user response:

refer to the second floor qq646748739 response:

Quote: refer to the original poster zys_qyy response:

ORA - 00932: data types inconsistent: should be -- but for BLOB does anyone know what's going on? Online, such as

What is the SQL statement? Posted to see see!

report how to add blob field directly, in the solution

CodePudding user response:

reference 5 floor jdsnhan reply:

I met is to use wm_concat connection, the content is too long, also prompt the error

how to join the blob field in a report