PL/SQL (MOSC)

MOSC Banner

ORA-00947: not enough values

edited Feb 17, 2012 12:34AM in PL/SQL (MOSC) 5 comments

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center