ORA-00947: not enough values
Hi ,
Below is my procedure .It is executing successfully .
CREATE OR REPLACE PROCEDURE PROD.RP_F0911 (
o_result OUT NUMBER,
i_opcode IN VARCHAR2,
i_CONTROL_NUMBER IN NUMBER,
i_UPDT_DT IN DATE,
ib_CONTROL_NUMBER IN NUMBER := NULL ,
ib_UPDT_DT IN DATE := NULL ,
ib_CRTD_DT IN DATE := NULL
) is
mms_record F0911%rowtype;
t_last_change_ts DATE;
BEGIN
IF i_opcode='UPDATE' OR i_opcode = 'INSERT' THEN
SELECT * into mms_record
FROM PROD.F0911
WHERE CONTROL_NUMBER=i_CONTROL_NUMBER
AND CONTROL_NUMBER=i_CONTROL_NUMBER for update;
END IF;
IF i_opcode='PK UPDATE' THEN