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!

all_views - ORA-00932

2788367Nov 13 2014 — edited Nov 13 2014

Hi all,

I'm trying to find view that gets information from %INVOICES% table.

select * from all_views where text like '%INVOICES%'

Got error:

ORA-00932: inconsistent datatypes: expected NUMBER got LONG

00932. 00000 -  "inconsistent datatypes: expected %s got %s"

*Cause:   

*Action:

Error at Line: 1 Column: 31

What is it and how to solve?

Thanks ahead.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2014
Added on Nov 13 2014
3 comments
1,032 views