ORA-01403: no data found
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01403: no data found

Threaded View

  1. #1
    Join Date
    Jul 2001

    Unhappy ORA-01403: no data found


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

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

    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;


    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,
    Last edited by Nikee; 12-18-2002 at 10: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

Click Here to Expand Forum to Full Width