Hi there,
I have a Oracle DB stored procedure which has the 1st argument as IN & OUT and some of the arguments are optional.
From ADF when I call this procedure I like to pass only required parameters. Please note 5th argument is the custom type table object.
For example here is the stored procedure structure:
PROCEDURE my_stored_proc (
arg1 IN OUT varchar2,
arg2 IN VARCHAR2 DEFAULT NULL,
arg3 IN VARCHAR2 DEFAULT 'N',
arg4 IN VARCHAR2,
arg5 IN CUSTOMTABLEOBJ DEFAULT NULL
)
..
..
..
..
END my_stored_proc;
I believe it is always better to call by named parameters from Oracle ADF.
Does anyone know how to do that? I only wanted to pass arg1 & arg4 using named parameters.
Thanks in advance!