Get size of LONG RAW data column in ORACLE

Question

I'm new to Oracle. I want to get size of binary data store in LONG RAW column, I execute this query

SELECT LENGTH(BINARY_DATA) FROM MY_DATATABLE WHERE ID = 58;

But I get error

ORA-00932: inconsistent datatypes: expected NUMBER got LONG BINARY

What wrong with my Query? Thanks.

**Do not use LONG datatype. Oracle advised to migrate to LOBs a long time ago** — Gurwinder Singh, Feb 27 '17 at 03:53
I working for a system create in 2001 , can not migrate because can not change the data structure ^^! — Ryo, Feb 27 '17 at 04:01
I don't think you'll find a good solution for this problem. You can look [here](http://stackoverflow.com/questions/5497238/get-the-length-of-a-long-raw) and see if this helps, but *it's time to upgrade.* — Gurwinder Singh, Feb 27 '17 at 04:15
You **can** change the data structure; you (or someone else) has chosen not to. — BobC, Feb 27 '17 at 04:59

score 0 · Answer 1 · answered Feb 27 '17 at 03:56

0

The LENGTHB function is supported for single-byte LOBs only. It cannot be used with CLOB and NCLOB data in a multibyte character set.

LENGTH() expects CHAR as it's parameter.

Documentation:LENGTH

answered Feb 27 '17 at 03:56

atokpas

1 Answers1