Ora-06550 Problem Urgent

[areya]

I'M GETTING a ora-06550 for the following stored procedures for line 1
column 7 wrong # or types of arguments. I have checked all I can. Your help is appreciated. the last column, REC_SEQ_NR, is just created for to insert a new Sequence/NextVal value. I do not know if that caused the problem.

********************************

CREATE OR REPLACE PACKAGE BODY EATS_DATA AS

PROCEDURE EATS_DATA_proc
(CALL_DT VARCHAR2, IVR VARCHAR2, CHAN VARCHAR2, CNY_CD VARCHAR2, LGU_TY_CD VARCHAR2, RCV NUMBER, REQ0 NUMBER, EMREQ0 NUMBER, DEF NUMBER, EMDEF NUMBER, HNG NUMBER, SUCCESS NUMBER, NIA NUMBER, BR1 NUMBER, BR2 NUMBER, BR3 NUMBER, BR4 NUMBER, EMREPEAT NUMBER, EMTAP NUMBER, EMHNG NUMBER, TRKNUM1 NUMBER, TRKNUM2 NUMBER, TRKNUM3 NUMBER, ATT1 NUMBER, ATT2 NUMBER, ATT3 NUMBER, DUR NUMBER, TOUT NUMBER, TCK_SUC_RCO_CAL_QY NUMBER, TCK_DTN_SUC_RRV_QY NUMBER, REC_SEQ_NR NUMBER) IS

BEGIN

INSERT INTO TTRACK VALUES
(to_date(CALL_DT, 'DD/MM/YYHH24:MI:SS'), NVL(IVR,'0001'), NVL(CHAN, '000'), NVL(CNY_CD,'NA'), NVL(LGU_TY_CD,'NA'), RCV, REQ0, EMREQ0, DEF, EMDEF, HNG, SUCCESS, NIA, BR1, BR2, BR3 , BR4, EMREPEAT, EMTAP, EMHNG, TRKNUM1, TRKNUM2, TRKNUM3, ATT1, ATT2, ATT3, DUR, TOUT, TCK_SUC_RCO_CAL_QY, TCK_DTN_SUC_RRV_QY, SEQ_TTRACK.NEXTVAL); COMMIT;

END EATS_DATA_proc;

END EATS_DATA;

[debasisdas]

As you have posted a question in the articles section it is being moved to Oracle Forum

MODERATOR.

[amitpatel66]

I'M GETTING a ora-06550 for the following stored procedures for line 1
column 7 wrong # or types of arguments. I have checked all I can. Your help is appreciated. the last column, REC_SEQ_NR, is just created for to insert a new Sequence/NextVal value. I do not know if that caused the problem.

********************************

CREATE OR REPLACE PACKAGE BODY EATS_DATA AS

PROCEDURE EATS_DATA_proc
(CALL_DT VARCHAR2, IVR VARCHAR2, CHAN VARCHAR2, CNY_CD VARCHAR2, LGU_TY_CD VARCHAR2, RCV NUMBER, REQ0 NUMBER, EMREQ0 NUMBER, DEF NUMBER, EMDEF NUMBER, HNG NUMBER, SUCCESS NUMBER, NIA NUMBER, BR1 NUMBER, BR2 NUMBER, BR3 NUMBER, BR4 NUMBER, EMREPEAT NUMBER, EMTAP NUMBER, EMHNG NUMBER, TRKNUM1 NUMBER, TRKNUM2 NUMBER, TRKNUM3 NUMBER, ATT1 NUMBER, ATT2 NUMBER, ATT3 NUMBER, DUR NUMBER, TOUT NUMBER, TCK_SUC_RCO_CAL_QY NUMBER, TCK_DTN_SUC_RRV_QY NUMBER, REC_SEQ_NR NUMBER) IS

BEGIN

INSERT INTO TTRACK VALUES
(to_date(CALL_DT, 'DD/MM/YYHH24:MI:SS'), NVL(IVR,'0001'), NVL(CHAN, '000'), NVL(CNY_CD,'NA'), NVL(LGU_TY_CD,'NA'), RCV, REQ0, EMREQ0, DEF, EMDEF, HNG, SUCCESS, NIA, BR1, BR2, BR3 , BR4, EMREPEAT, EMTAP, EMHNG, TRKNUM1, TRKNUM2, TRKNUM3, ATT1, ATT2, ATT3, DUR, TOUT, TCK_SUC_RCO_CAL_QY, TCK_DTN_SUC_RRV_QY, SEQ_TTRACK.NEXTVAL); COMMIT;

END EATS_DATA_proc;

END EATS_DATA;

What is the reason behind you using a package/procedure for just INSERT statement. You can execute the INSERT statement seperately rather putting it in a procedure.
And in the insert statement, I see you have used a SEQUENCE to AUTOGENERATE a value for the last column then WHY you need to pass it as a parameter to the PROCEDURE.Anyways you will not be using the value of the last column that you pass to the procedure in the INSERT statement.