-
ORA-01403: no data found
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
Last edited by Nikee; 12-18-2002 at 11:39 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|