Home » Developer & Programmer » Reports & Discoverer » ora-00997 illegal use of long datatype
ora-00997 illegal use of long datatype [message #183080] Wed, 19 July 2006 05:34
ranisri321
Messages: 22
Registered: March 2006
Location: hyderabad
Junior Member
hi
I have one table with long raw column.
In the report if i write query with using this table only.It is retriving image fine.
but if use columns of 2 tables it is giving error like
ora-00997 illegal use of long datatype.

iam giving u the tables desc.
1) desc image;
sign long raw
name varchar2(100)

2) desc emp
eno number
address varchar2(20)
ename varchar2(100)

the query in the report is select eno,address,ename,sign from image,emp

it is giving error like ora 00997

if i write quere like select name,sign from image it is working fine
can any one help me
thanks in advance


Previous Topic: Disable print button in previewer
Next Topic: reports 6i
Goto Forum:
  


Current Time: Tue Nov 26 13:49:09 CST 2024