The procedure is running fine in the Oracle SQL developer. But when I want to run the same procedure using Control-M database job it is showing me below error:
Job failure message: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'EXE_SUBPARTITION_PARAM_QRY' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Also while passing parameter list in Control-M, it is giving Parameter type as "UNDEFINED" for using ORACLE pre-defined table type "odcivarchar2list" in my procedure.
I know that BOOLEAN type is not supported by Control-M, is this applies to oracle pre-defined types too!
Many thanks for your help.