Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01422: exact fetch returns more than requested number of rows
ORA-01422: exact fetch returns more than requested number of rows [message #212349] Thu, 04 January 2007 20:02 Go to next message
alamax
Messages: 8
Registered: October 2006
Location: KL
Junior Member
05-JAN-07 SP_EQPT_HEAD_STATUS_HISTORY
101070 -1422
ORA-01422: exact fetch returns more than requested number of rows

05-JAN-07 SP_EQPT_HEAD_STATUS
-1002
ORA-01002: fetch out of sequence

TIMESTAMP PROGRAM
--------- --------------------------------------------------
TABLENAME CODE
-------------------------------------------------- ----------
MESSAGE

How can I solve the above issue?
Re: ORA-01422: exact fetch returns more than requested number of rows [message #212357 is a reply to message #212349] Thu, 04 January 2007 20:48 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>How can I solve the above issue?
Since you did not post the code that produced these errors,
I refuse to guess at any possible solution beyond saying that the code needs to be changed to eliminate these errors.

01422, 00000, "exact fetch returns more than requested number of rows"
// *Cause: The number specified in exact fetch is less than the rows returned.
// *Action: Rewrite the query or change number of rows requested

[Updated on: Thu, 04 January 2007 20:53] by Moderator

Report message to a moderator

Re: ORA-01422: exact fetch returns more than requested number of rows [message #212361 is a reply to message #212357] Thu, 04 January 2007 21:25 Go to previous messageGo to next message
alamax
Messages: 8
Registered: October 2006
Location: KL
Junior Member
You mean you need the code that this code create the issue. Is it right?
Re: ORA-01422: exact fetch returns more than requested number of rows [message #212394 is a reply to message #212361] Fri, 05 January 2007 02:21 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What you said was this: "I've got a car but its engine doesn't start. Why?" It is impossible to help unless you provide more information. Error codes are fine, but not enough.

As Anacedent told you (quote): "the code needs to be changed to eliminate these errors".

P.S. Here is your another error description. See if any of those help.
Quote:
ORA-01002: fetch out of sequence

Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error. There are a number of possible causes for this error, including: 1) Fetching from a cursor after the last row has been retrieved and the ORA-1403 error returned. 2) If the cursor has been opened with the FOR UPDATE clause, fetching after a COMMIT has been issued will return the error. 3) Rebinding any placeholders in the SQL statement, then issuing a fetch before reexecuting the statement.

Action: 1) Do not issue a fetch statement after the last row has been retrieved - there are no more rows to fetch. 2) Do not issue a COMMIT inside a fetch loop for a cursor that has been opened FOR UPDATE. 3) Reexecute the statement after rebinding, then attempt to fetch again.
icon2.gif  Re: ORA-01422: exact fetch returns more than requested number of rows [message #212403 is a reply to message #212361] Fri, 05 January 2007 03:32 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
no i mean the sql statement whichc you issued
Re: ORA-01422: exact fetch returns more than requested number of rows [message #212461 is a reply to message #212349] Fri, 05 January 2007 07:32 Go to previous messageGo to next message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
alamax wrote on Thu, 04 January 2007 21:02
05-JAN-07 SP_EQPT_HEAD_STATUS_HISTORY
101070 -1422
ORA-01422: exact fetch returns more than requested number of rows

05-JAN-07 SP_EQPT_HEAD_STATUS
-1002
ORA-01002: fetch out of sequence

TIMESTAMP PROGRAM
--------- --------------------------------------------------
TABLENAME CODE
-------------------------------------------------- ----------
MESSAGE

How can I solve the above issue?


To solve the first error, don't return more rows than you fetch.
To solve the second error, don't fetch out of sequence.
Re: ORA-01422: exact fetch returns more than requested number of rows [message #213684 is a reply to message #212461] Thu, 11 January 2007 19:20 Go to previous messageGo to next message
alamax
Messages: 8
Registered: October 2006
Location: KL
Junior Member
I just off days for 5 days. What is the command to solve the above issue?

[Updated on: Thu, 11 January 2007 19:22]

Report message to a moderator

Re: ORA-01422: exact fetch returns more than requested number of rows [message #213687 is a reply to message #213684] Thu, 11 January 2007 21:18 Go to previous messageGo to next message
alamax
Messages: 8
Registered: October 2006
Location: KL
Junior Member
[EDIT by Moderator] Please, use [code] tags next time to improve readability.

CREATE OR REPLACE  PROCEDURE 
    "SYSTEM"."SP_EQPT_HEAD_STATUS_HISTORY" (TableName OUT NOCOPY 
    VARCHAR2)  is
V_UNSCHEDULE_DOWN   NUMBER(9);
V_SCHEDULE_DOWN     NUMBER(9);
V_UNSCHEDULE_WAIT   NUMBER(9);
V_UNSCHEDULE_REPAIR NUMBER(9);
V_SCHEDULE_REPAIR   NUMBER(9);
V_SCHEDULE_WAIT     NUMBER(9);
V_STANDBY           NUMBER(9);
V_ENGINEERING       NUMBER(9);
V_PRODUCTIVE        NUMBER(9);
V_NON_SCHEDULE      NUMBER(9);
V_DAY_RRN           NUMBER(15);

V_RECORD_NUM        NUMBER(8);   --FOR CHECK DUPLICATE KEY USING
-- V_DAY_COUNT         VARCHAR2(32);--FOR CURSOR C_EQPTDAY USING
-- V_MAX_DAYRRN        NUMBER(15);  --FOR GET MAX DAYRRN FROM EQUIPMENT_STATUS_HEAD_HISTORY
TP_TIME             DATE;

V_START_TIME   DATE;
V_END_TIME   DATE;

V_EQPT_EVENT_COUNT   NUMBER(32);

CURSOR C_EQPTEVENT IS
SELECT E_V.EQUIPMENT_RRN,E_M.EQUIPMENT_ID,E_M.FACILITY_RRN,E_M.FACILITY_ID,
       E_V.EVENT_ID,E_V.TRANS_ID,E_V.STATUS_START_TIMESTAMP,
       E_V.STATUS_END_TIMESTAMP,E_V.STATUS_KEEP_TIME,E_V.EQUIPMENT_STATUS1
FROM EQUIPMENT_EVENT_HISTORY E_V,EQPT_SEQ E_S,EQUIPMENT_MASTER E_M
WHERE E_V.EQUIPMENT_RRN=E_S.EQPT_RRN
AND   E_V.HIST_SEQ>E_S.HIST_SEQ
AND E_V.EQUIPMENT_RRN=E_M.EQUIPMENT_RRN(+)
UNION
SELECT E_V.EQUIPMENT_RRN,E_M.EQUIPMENT_ID,E_M.FACILITY_RRN,E_M.FACILITY_ID,
       E_V.EVENT_ID,E_V.TRANS_ID,E_V.STATUS_START_TIMESTAMP,
       E_V.STATUS_END_TIMESTAMP,E_V.STATUS_KEEP_TIME,E_V.EQUIPMENT_STATUS1
FROM EQUIPMENT_EVENT_HISTORY E_V,EQUIPMENT_MASTER E_M
WHERE E_V.EQUIPMENT_RRN NOT IN (SELECT EQPT_RRN FROM EQPT_SEQ)
AND E_V.EQUIPMENT_RRN=E_M.EQUIPMENT_RRN(+);

begin
  FOR C_EQPT IN C_EQPTEVENT LOOP
      V_UNSCHEDULE_DOWN:=0;
      V_SCHEDULE_DOWN:=0;
      V_UNSCHEDULE_WAIT:=0;
      V_UNSCHEDULE_REPAIR:=0;
      V_SCHEDULE_REPAIR:=0;
      V_SCHEDULE_WAIT:=0;
      V_STANDBY:=0;
      V_ENGINEERING:=0;
      V_PRODUCTIVE:=0;
      V_NON_SCHEDULE:=0;
      V_START_TIME:=C_EQPT.STATUS_START_TIMESTAMP;
      V_END_TIME:=C_EQPT.STATUS_END_TIMESTAMP;
      while TO_CHAR(V_END_TIME,'YYYY/MM/DD') >TO_CHAR(V_START_TIME,'YYYY/MM/DD')
          loop
          TP_TIME:=TO_DATE(TO_CHAR(V_START_TIME,'YYYY/MM/DD'),'YYYY/MM/DD');
          --FOR UNSCHEDULE WAIT TIME
          IF C_EQPT.EQUIPMENT_STATUS1='CALIBRATE'  OR C_EQPT.EQUIPMENT_STATUS1='AWAITG CALIB'
                                                   OR C_EQPT.EQUIPMENT_STATUS1='AWAITG REPR'  THEN
             V_UNSCHEDULE_WAIT:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF;   --END OF FOR UNSCHEDULE WAIT TIME
          --FOR UNSCHEDULE REPAIR TIME
          IF C_EQPT.EQUIPMENT_STATUS1='REPAIR'  THEN
             V_UNSCHEDULE_REPAIR:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF; -- END OF FOR UNSCHEDULE REPAIR TIME
          --FOR SCHEDULE REPAIR TIME
          IF C_EQPT.EQUIPMENT_STATUS1='PM'  THEN
             V_SCHEDULE_REPAIR:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF; -- END OF FOR SCHEDULE REPAIR TIME
          --FOR SCHEDULE_WAIT_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='AWAITG PM'  THEN
             V_SCHEDULE_WAIT:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF;-- END OF SCHEDULE_WAIT_TIME
          --FOR STANDBY_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='HOLD' OR C_EQPT.EQUIPMENT_STATUS1='IDLE' 
                                             OR C_EQPT.EQUIPMENT_STATUS1='READY'  THEN
             V_STANDBY:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF;--END OF STANDBY_TIME
          --FOR ENGINEERING_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='ENG'   THEN
             V_ENGINEERING:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF;--END OF FOR ENGINEERING_TIME
          --FOR PRODUCTIVE_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='PROD'   THEN
             V_PRODUCTIVE:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF;--END OF FOR PRODUCTIVE_TIME
          --FOR NON_SCHEDULE_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='INSTALLED'  OR  C_EQPT.EQUIPMENT_STATUS1='ACCEPTANCE' THEN
             V_NON_SCHEDULE:=(TP_TIME+1-V_START_TIME)*24*3600;
          END IF;--END OF FOR NON_SCHEDULE_TIME
          --FOR UNSCHEDULE_DOWN_TIMES
          SELECT COUNT(*) into V_UNSCHEDULE_DOWN FROM EQUIPMENT_EVENT_HISTORY 
          WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN 
          AND
          STATUS_START_TIMESTAMP>=TP_TIME
          AND
          STATUS_START_TIMESTAMP<=TP_TIME+1
          AND
          EVENT_ID='DOWN';
          --FOR SCHEDULE_DOWN_TIMES
          SELECT COUNT(*) into V_SCHEDULE_DOWN FROM EQUIPMENT_EVENT_HISTORY 
          WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN 
          AND
          STATUS_START_TIMESTAMP>=TP_TIME
          AND
          STATUS_START_TIMESTAMP<=TP_TIME+1
          AND
          EVENT_ID='SCHD PM';
          --FOR DAY_RRN
          SELECT DAY_RRN INTO V_DAY_RRN FROM DAY_MASTER
          WHERE CALENDAR_DATE=TP_TIME
          AND FACILITY_RRN=C_EQPT.FACILITY_RRN;
          --CHECK IF HAVE DUPLICATE KEY
          SELECT COUNT(*) INTO V_RECORD_NUM FROM EQUIPMENT_STATUS_HEAD_HISTORY
          WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN  AND DAY_RRN=V_DAY_RRN;
          --FOR UPDATE TABLE 
          IF V_RECORD_NUM=0 THEN  
              --INSERT INTO EQUIPMENT_STATUS_HEAD_HISTORY
              INSERT INTO EQUIPMENT_STATUS_HEAD_HISTORY
              (EQUIPMENT_RRN,EQUIPMENT_ID,DAY_RRN,CALENDAR_DATE,FACILITY_RRN,FACILITY_ID
              ,UNSCHEDULE_DOWN_TIMES,SCHEDULE_DOWN_TIMES,UNSCHEDULE_WAIT_TIME
              ,UNSCHEDULE_REPAIR_TIME,SCHEDULE_REPAIR_TIME,SCHEDULE_WAIT_TIME
              ,STANDBY_TIME,ENGINEERING_TIME,PRODUCTIVE_TIME,NON_SCHEDULE_TIME)
              VALUES(C_EQPT.EQUIPMENT_RRN,C_EQPT.EQUIPMENT_ID,V_DAY_RRN,TP_TIME,
                     C_EQPT.FACILITY_RRN,C_EQPT.FACILITY_ID,
                     V_UNSCHEDULE_DOWN,V_SCHEDULE_DOWN,V_UNSCHEDULE_WAIT,
                     V_UNSCHEDULE_REPAIR,V_SCHEDULE_REPAIR,V_SCHEDULE_WAIT,
                     V_STANDBY,V_ENGINEERING,V_PRODUCTIVE,V_NON_SCHEDULE);
          ELSE
              UPDATE EQUIPMENT_STATUS_HEAD_HISTORY
              SET    --UNSCHEDULE_DOWN_TIMES=UNSCHEDULE_DOWN_TIMES+V_UNSCHEDULE_DOWN,
                     UNSCHEDULE_DOWN_TIMES=V_UNSCHEDULE_DOWN,
                     --SCHEDULE_DOWN_TIMES=SCHEDULE_DOWN_TIMES+V_SCHEDULE_DOWN,
                     SCHEDULE_DOWN_TIMES=V_SCHEDULE_DOWN,
                     UNSCHEDULE_WAIT_TIME=UNSCHEDULE_WAIT_TIME+V_UNSCHEDULE_WAIT,
                     UNSCHEDULE_REPAIR_TIME=UNSCHEDULE_REPAIR_TIME+V_UNSCHEDULE_REPAIR,
                     SCHEDULE_REPAIR_TIME=SCHEDULE_REPAIR_TIME+V_SCHEDULE_REPAIR,
                     SCHEDULE_WAIT_TIME=SCHEDULE_WAIT_TIME+V_SCHEDULE_WAIT,
                     STANDBY_TIME=STANDBY_TIME+V_STANDBY,
                     ENGINEERING_TIME=ENGINEERING_TIME+V_ENGINEERING,
                     PRODUCTIVE_TIME=PRODUCTIVE_TIME+V_PRODUCTIVE,
                     NON_SCHEDULE_TIME=NON_SCHEDULE_TIME+V_NON_SCHEDULE
              WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN  AND DAY_RRN=V_DAY_RRN;
          END IF;--END FOR UPDATE TABLE
          --CHANGE THE VALUE OF V_START_TIME
          V_START_TIME:=TO_DATE(TO_CHAR(V_START_TIME,'YYYY/MM/DD'),'YYYY/MM/DD')+1;
     end loop;    
          
           
    IF TO_CHAR(V_END_TIME,'YYYY/MM/DD')=TO_CHAR(V_START_TIME,'YYYY/MM/DD')THEN
          TP_TIME:=TO_DATE(TO_CHAR(V_START_TIME,'YYYY/MM/DD'),'YYYY/MM/DD');
          --FOR UNSCHEDULE WAIT TIME
          IF C_EQPT.EQUIPMENT_STATUS1='CALIBRATE'  OR C_EQPT.EQUIPMENT_STATUS1='AWAITG CALIB'
                                                   OR C_EQPT.EQUIPMENT_STATUS1='AWAITG REPR'  THEN
             V_UNSCHEDULE_WAIT:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF;   --END OF FOR UNSCHEDULE WAIT TIME
          --FOR UNSCHEDULE REPAIR TIME
          IF C_EQPT.EQUIPMENT_STATUS1='REPAIR'  THEN
             V_UNSCHEDULE_REPAIR:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF; -- END OF FOR UNSCHEDULE REPAIR TIME
          --FOR SCHEDULE REPAIR TIME
          IF C_EQPT.EQUIPMENT_STATUS1='PM'  THEN
             V_SCHEDULE_REPAIR:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF; -- END OF FOR SCHEDULE REPAIR TIME
          --FOR SCHEDULE_WAIT_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='AWAITG PM'  THEN
             V_SCHEDULE_WAIT:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF;-- END OF SCHEDULE_WAIT_TIME
          --FOR STANDBY_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='HOLD' OR C_EQPT.EQUIPMENT_STATUS1='IDLE' 
                                             OR C_EQPT.EQUIPMENT_STATUS1='READY'  THEN
             V_STANDBY:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF;--END OF STANDBY_TIME
          --FOR ENGINEERING_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='ENG'   THEN
             V_ENGINEERING:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF;--END OF FOR ENGINEERING_TIME
          --FOR PRODUCTIVE_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='PROD'   THEN
             V_PRODUCTIVE:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF;--END OF FOR PRODUCTIVE_TIME
          --FOR NON_SCHEDULE_TIME
          IF C_EQPT.EQUIPMENT_STATUS1='INSTALLED'  OR  C_EQPT.EQUIPMENT_STATUS1='ACCEPTANCE' THEN
             V_NON_SCHEDULE:=(V_END_TIME-V_START_TIME)*24*3600;
          END IF;--END OF FOR NON_SCHEDULE_TIME
          --FOR UNSCHEDULE_DOWN_TIMES
          SELECT COUNT(*) into V_UNSCHEDULE_DOWN FROM EQUIPMENT_EVENT_HISTORY 
          WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN 
          AND
          STATUS_START_TIMESTAMP>=TP_TIME
          AND
          STATUS_START_TIMESTAMP<=TP_TIME+1
          AND
          EVENT_ID='DOWN';
          --FOR SCHEDULE_DOWN_TIMES
          SELECT COUNT(*) into V_SCHEDULE_DOWN FROM EQUIPMENT_EVENT_HISTORY 
          WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN 
          AND
          STATUS_START_TIMESTAMP>=TP_TIME
          AND
          STATUS_START_TIMESTAMP<=TP_TIME+1
          AND
          EVENT_ID='SCHD PM';
          --FOR DAY_RRN
          SELECT DAY_RRN INTO V_DAY_RRN FROM DAY_MASTER
          WHERE CALENDAR_DATE=TP_TIME
          AND FACILITY_RRN=C_EQPT.FACILITY_RRN;
          --CHECK IF HAVE DUPLICATE KEY
          SELECT COUNT(*) INTO V_RECORD_NUM FROM EQUIPMENT_STATUS_HEAD_HISTORY
          WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN  AND DAY_RRN=V_DAY_RRN;
          IF V_RECORD_NUM=0 THEN  
              --INSERT INTO EQUIPMENT_STATUS_HEAD_HISTORY
              INSERT INTO EQUIPMENT_STATUS_HEAD_HISTORY
              (EQUIPMENT_RRN,EQUIPMENT_ID,DAY_RRN,CALENDAR_DATE,FACILITY_RRN,FACILITY_ID
              ,UNSCHEDULE_DOWN_TIMES,SCHEDULE_DOWN_TIMES,UNSCHEDULE_WAIT_TIME
              ,UNSCHEDULE_REPAIR_TIME,SCHEDULE_REPAIR_TIME,SCHEDULE_WAIT_TIME
              ,STANDBY_TIME,ENGINEERING_TIME,PRODUCTIVE_TIME,NON_SCHEDULE_TIME)
              VALUES(C_EQPT.EQUIPMENT_RRN,C_EQPT.EQUIPMENT_ID,V_DAY_RRN,TP_TIME,
                     C_EQPT.FACILITY_RRN,C_EQPT.FACILITY_ID,
                     V_UNSCHEDULE_DOWN,V_SCHEDULE_DOWN,V_UNSCHEDULE_WAIT,
                     V_UNSCHEDULE_REPAIR,V_SCHEDULE_REPAIR,V_SCHEDULE_WAIT,
                     V_STANDBY,V_ENGINEERING,V_PRODUCTIVE,V_NON_SCHEDULE);
          ELSE
              UPDATE EQUIPMENT_STATUS_HEAD_HISTORY
              SET    --UNSCHEDULE_DOWN_TIMES=UNSCHEDULE_DOWN_TIMES+V_UNSCHEDULE_DOWN,
                     UNSCHEDULE_DOWN_TIMES=V_UNSCHEDULE_DOWN,
                     --SCHEDULE_DOWN_TIMES=SCHEDULE_DOWN_TIMES+V_SCHEDULE_DOWN,
                     SCHEDULE_DOWN_TIMES=V_SCHEDULE_DOWN,
                     UNSCHEDULE_WAIT_TIME=UNSCHEDULE_WAIT_TIME+V_UNSCHEDULE_WAIT,
                     UNSCHEDULE_REPAIR_TIME=UNSCHEDULE_REPAIR_TIME+V_UNSCHEDULE_REPAIR,
                     SCHEDULE_REPAIR_TIME=SCHEDULE_REPAIR_TIME+V_SCHEDULE_REPAIR,
                     SCHEDULE_WAIT_TIME=SCHEDULE_WAIT_TIME+V_SCHEDULE_WAIT,
                     STANDBY_TIME=STANDBY_TIME+V_STANDBY,
                     ENGINEERING_TIME=ENGINEERING_TIME+V_ENGINEERING,
                     PRODUCTIVE_TIME=PRODUCTIVE_TIME+V_PRODUCTIVE,
                     NON_SCHEDULE_TIME=NON_SCHEDULE_TIME+V_NON_SCHEDULE
              WHERE EQUIPMENT_RRN=C_EQPT.EQUIPMENT_RRN  AND DAY_RRN=V_DAY_RRN;
          END IF;                                             
      END IF;
  END LOOP;
  --GET THE LATTEST HIST_SEQ OF TABLE EQUIPMENT_EVENT_HISTORY
  V_EQPT_EVENT_COUNT:=0;
  DELETE FROM EQPT_SEQ;
  SELECT COUNT(*) INTO V_EQPT_EVENT_COUNT FROM EQUIPMENT_EVENT_HISTORY;
  IF V_EQPT_EVENT_COUNT>0 THEN
    INSERT INTO EQPT_SEQ(EQPT_RRN,HIST_SEQ)
    SELECT EQUIPMENT_RRN,MAX(HIST_SEQ) FROM EQUIPMENT_EVENT_HISTORY
    GROUP BY EQUIPMENT_RRN; 
  END IF;
  
end SP_EQPT_HEAD_STATUS_HISTORY;

[Updated on: Fri, 12 January 2007 00:21] by Moderator

Report message to a moderator

Re: ORA-01422: exact fetch returns more than requested number of rows [message #213709 is a reply to message #213687] Fri, 12 January 2007 00:23 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, where exactly did you get those errors?

BTW, although it has nothing to do with your problem, it is a bad idea to store your objects in to a SYSTEM schema.
Previous Topic: Function-based index not used
Next Topic: Need to change table space of existing Index
Goto Forum:
  


Current Time: Wed Dec 07 03:02:09 CST 2016

Total time taken to generate the page: 0.13979 seconds