Hi Guys,
I have a table which contains a long RAW type as field. I have queried
the same table using select statement i got the following error.
Inconsistent Data type.
Could any one tell me the query for this.
Regards,
Sudheer
Printable View
Hi Guys,
I have a table which contains a long RAW type as field. I have queried
the same table using select statement i got the following error.
Inconsistent Data type.
Could any one tell me the query for this.
Regards,
Sudheer
refer to dbms_lob
what is the select statement
somethink like
desc t1;
col1 int
col2 long
select col1 from t1 where col2 like '%yadda yadda yadda%';
If so you will have to do this through pl/sql
look on asktom.oracle.com and search on "where long select datatype"
for clues on how to do this.
steve
Hi Sudheer,
It seems you are chasing the lengthy type of data to be extracted from database through the querying.
but,
Mind it the sql buffer is first and foremost thing to be placed your return result.
usage of DBMS_ related packages will only adequate to get the result.
If you are working in Chennai TCS or any top MNC co. then you will get the manuals for viewing.
since the data cannot be viewed as it consists like a several pages to tresspass so better be it fix in to the file allocation.
Hope your previous query (CLOB) also fix the same note.
Hope you achive this
VAST