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!

Select LONG RAW datatype error in PL/SQL

823817Dec 14 2010 — edited Dec 16 2010
I am working with a legacy application that works with LONG RAW datatypes and I need to SELECT a LONG RAW column but PL/SQL gives me an error when I try do this.

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

Doing some research, LONG RAW is only supported for backward compatibility and should be replaced with LOB.

I tried to declare the variable as BLOB(just to see what would happen) but that failed to.

My next step is to alter the column datatype from LONG RAW to BLOB but if I don't have to do that, then I was wondering if there is another way in which I can get this data?

Thanks for your help,

William.

Edited by: user13477496 on Dec 14, 2010 8:07 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2011
Added on Dec 14 2010
8 comments
3,639 views