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
    Posts
    108

    Unhappy 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 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