Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00932: inconsistent datatypes: expected - got BLOB

994207May 10 2013 — edited May 10 2013
I havev a table with two columns, blob with datatype blob and text with datatype varchar2(20).

It is empty or filled with one row that has NULL/"some text". I run this query on it: "SELECT * FROM ( SELECT blob FROM okay ORDER BY blob DESC ) WHERE ROWNUM <= 1"

But I get the error "ORA-00932: inconsistent datatypes: expected - got BLOB"

What's a "-" type? Why was that expected?

I had the query translated from this TSQL:

"SELECT TOP(1) blob FROM okay ORDER BY blob DESC"
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2013
Added on May 10 2013
#plsql, #sql-developer
1 comment
718 views