ORA-01403: no data found

[rotem_fo]

Hi,
You can use EXCEPTIONS:

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;

EXCEPTIONS
WHEN NO_DATA_FOUND
DBMS_OUTPUT.PUT_LINE('No Data Found');

END;
/

Cheers.