<div>
What is the datatype of doc_document?<br />
<br />
The following snippet works in 10.2.0.3<br />

<pre><code id="code-168945">drop table tab1;
create table tab1 ( col1 BLOB ); 
insert into tab1 values('48656C6C6F');
commit; 
select utl_raw.cast_to_varchar2(dbms_lob.substr(col1,5,1)) from tab1;
</code></pre>
</div>


What is the datatype of doc_document?

The following snippet works in 10.2.0.3


drop table tab1;
create table tab1 ( col1 BLOB ); 
insert into tab1 values('48656C6C6F');
commit; 
select utl_raw.cast_to_varchar2(dbms_lob.substr(col1,5,1)) from tab1;


<div>
<div class="content wysiwyg-content">
When i try to retrive the data from Doc_Document using the below query i am getting an error ORA-00997: illegal use of LONG datatype.<br />
select utl_raw.cast_to_varchar2( dbms_lob.substr( doc_document, 2000, 1 ) )<br />
from LN_FIN.eul5_documents<br />
where doc_name like '%Captiva%';
</div>
</div>


When i try to retrive the data from Doc_Document using the below query i am getting an error ORA-00997: illegal use of LONG datatype.
select utl_raw.cast_to_varchar2( dbms_lob.substr( doc_document, 2000, 1 ) )
from LN_FIN.eul5_documents
where doc_name like '%Captiva%';

ORA-00997: illegal use of LONG datatype

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.