CODEWITHSUNDEEP
oracle-databasestored-proceduresplsqlcontrol-moracle-type
Sneha
Sneha

Reputation: 45

Does anyone know if the Control-M job designed to run stored procedure accepts parameter with ORACLE pre-defined table type "odcivarchar2list"

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.

Upvotes: 0

Views: 767

Answers (1)

user27465979
user27465979

Reputation: 1

You can change the Execution Type from Stored Procedure to Embedded Query then put the following:

BEGIN
    schema.package_name.procedure(TRUE);
END;
/

Upvotes: 0

Related Questions