DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.