I have 3 parameters that a procedure receives, how do I pass the values for the variables err_buff and ret_code ?, as null ?, I mark the errors of invalid number of parameters
PROCEDURE XX7E_EXT_FAC(err_buf OUT VARCHAR2,ret_code OUT NUMBER, P_TRX_NUM VARCHAR2, P_CUST_NAME VARCHAR2, P_CUST_ID VARCHAR2);
PLS-00306: wrong number or types
The error PLS-00306 is shown when you try to execute a procedure and the call does not specify the correct number of parameters of the procedure or the types of these parameters are not the same in the call to the procedure as those of the creation.
By the name of the variables that you placed in the procedure call you may have declared the variable P_TRX_NUM as NUMBER .