| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
