cancel
Showing results for 
Search instead for 
Did you mean: 

Error: illegal use of Long datatype in Webi report

Former Member
0 Kudos

Dear Experts,

I am getting the error for the dimension object in Webi report based on Oracle database.

Error - illegal use of long data-type

In Oracle database Object data-type is long() where as in Universe it has long-text by default, the object values in database is (Null)

Can any one help me to resolve this issue.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos
ORA-00997: illegal use of LONG datatype
Cause: A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.
Action: Remove the LONG value from the function or clause.

I would suggest you to create separate object on universe with defination like

=TO_LOB(actual column having LONG datatype)

I hope this will help.

If any other issue let me know.

Thanks,

Swapnil