Devart Forums

If I try to open this UniQuery on an oracle 10g database:

"SELECT VIEW_NAME FROM ALL_VIEWS WHERE TEXT LIKE '%MY_TABLE%'"
I get the following error:

"# ORA-00932: Inconsistent data types: got NUMBER instead of LONG"
(manually translated from german to english, so it might differ a little bit)

Is this an oracle bug or an unidac bug? Using "SELECT VIEW_NAME,TEXT FROM ALL_VIEWS WHERE ROWNUM < 2" works ok...

Greetz
Detlev Moehring

OK, got it: It's an oracle bug! The same error occurs using SQLPLus!
Every query using "TEXT" field in where clause will fail ...

Thread can be closed!

You get this error because Oracle does not allow to use LIKE operator with columns of LONG type.

But this error will occur if you don't use "LIKE" either:

SELECT VIEW_NAME FROM USER_VIEWS
WHERE TEXT = 'TEST'

will fail too!

Is there any other way looking for views that reference a specific table?

Greetz
Detlev Moehring

You cannot use LONG columns in WHERE.

Use USER_DEPENDENCIES view to find views that reference a specific table.