ORA-01403: no data found - Returned from PL/SQL but data exists

From: oichi <prettyruchi_at_gmail.com>
Date: 20 Jun 2006 16:57:15 -0700
Message-ID: <1150847835.835443.175760@u72g2000cwu.googlegroups.com>

Hi

I am new to PL/SQL.

Here's the problem
..
..

  CURSOR Cur_Network IS
    select sznetwork, szdescription from EM_X_NETWORK WHERE ulmigrationid = MigrationID;

  NetworkCode EM_X_NETWORK.sznetwork%type;   NetworkDesc EM_X_NETWORK.szdescription%type;

  ULID                        NUMBER;
  Network                     CHAR(4);

BEGIN
  ReturnCode := 0;

  OPEN Cur_Network;
  FETCH Cur_Network into NetworkCode, NetworkDesc ;

   IF (Cur_Network%NOTFOUND) THEN

      RAISE No_Data_Found;
   END IF;   WHILE Cur_Network%FOUND
  LOOP
    BEGIN        Network := TRIM(NetworkCode);

• The problem sql that returns the no data found error

        SELECT SZNETWORK INTO Network FROM Eclipse.X_NETWORK WHERE TRIM(SZNETWORK)= TRIM(Network);

• The NetworkCode could be Names Like 'CNN' , 'ABC' etc...
  • SZNETWORK is CHAR(4) and NetworkCode is also CHAR(4)
• I know the Eclipse.X_Network Table has equivalent matches

      FETCH Cur_Network into NetworkCode, NetworkDesc;

  END LOOP; Any Help would be appreciated

Thanx
Oichi Received on Tue Jun 20 2006 - 18:57:15 CDT