2 Replies Latest reply: Aug 9, 2010 3:47 PM by Hussein Sawwan-Oracle RSS

    ora-01422

    787218
      HI EXPERTS

      I AM HAVING PROBLEM WITH MY QUERY. WHEN I AM EXECUTING, I am getting ORA-01422: Exact fetch returns more than requested number of rows.

      my query is as follows:

      SELECT NVL(export_flag,'Y')
      INTO v_export_flag
      FROM MANUAL_BOULDERS_TRIPS
      WHERE TRX_DATE BETWEEN NVL(:block3.FROM_DATE,TRX_DATE) AND NVL(:block3.TO_DATE,TRX_DATE);

      I NEED TO TAKE ALL THE EXPORT_FLAGS WHICH CONTAIN THE VALUE 'Y' in the table BUT ITS NOT WORKING