ORA-01403: no data found

[Nikee]

Hello,

When I tried to execute the following PL/SQL code, I am facing the ORA-01403: no data found error:

------------------------------------------------------------
DECLARE
Tname varchar2(30) := 'CUSTOM';
Crows Integer(10);
Long varchar2(106);
BEGIN

Execute Immediate 'select data_type from DBA_TAB_COLUMNS where data_type=''LONG RAW'''||' and table_name='''||Tname||'''' into Long;

If Long = 'LONG RAW' Then
dbms_output.put_line( Tname );
End If;

END;
/

------------------------------------------------------------
Error Message:

ERROR at line 1:
ORA-01403: no data found
------------------------------------------------------------

The error is occuring when the Execute Immediate statement returns an empty value. The happens if the table do not contain LONG RAW data_type.

I do not know how to handle this?

ThanK You,
Seenu