Hi,
I have created a procedure (Pasted below). Getting error on execution, please help me to overcome from the error.
BEGIN
Log('6B6C6D','06-Aug-12','COM.TESt','OH','AUT','NOTRANSACT','<ACORD><SignonRq>','000000E0LN1D000029FNSRRGTest','000009N1D000029FNJ9OITest');
END;
ERROR
Error report:
ORA-06550: line 3, column 1:
PLS-00306: wrong number or types of arguments in call to 'LOG'
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
/************************ Procedure *************************/
create or replace PROCEDURE log
/****** Object: StoredProcedure [dbo].[LogTransactionBegin] Script Date: 07/06/2012 05:37:06 ******/
(
v_GUID IN RAW DEFAULT NULL ,
v_STRT_TM IN TIMESTAMP DEFAULT NULL ,
v_PRTN_NM IN VARCHAR2 DEFAULT NULL ,
v_ST_CD IN CHAR DEFAULT NULL ,
v_LN_OF_BUS IN VARCHAR2 DEFAULT NULL ,
v_TRN_TYP IN VARCHAR2 DEFAULT NULL ,
v_REQ_XML IN XMLTYPE DEFAULT NULL ,
v_INNR_RQUID IN VARCHAR2 DEFAULT NULL ,
v_OUTR_RQUID IN VARCHAR2 DEFAULT NULL
)
AS
BEGIN
INSERT INTO trn_log
( GIRO_TRN_LOG_ID, STRT_TM, PRTN_NM, ST_CD, LN_OF_BUS, TRN_TYP, REQ_XML, INNR_RQUID, OUTR_RQUID )
VALUES ( v_GUID, v_STRT_TM, v_PRTN_NM, v_ST_CD, v_LN_OF_BUS, v_TRN_TYP, v_REQ_XML, v_INNR_RQUID, v_OUTR_RQUID );
END;