long RAW datatype

[sudheer_nm]

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

[Sameer]

refer to dbms_lob

[stmontgo]

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

[vastdba]

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