I need to run dbms_spm.evolve_sql_plan_baseline function in jdbc. dbms_spm.evolve_sql_plan_baseline has a input paramter plan_list type as DBMS_SPM.NAME_LIST,
What type should set for NAME_LIST in OracleCallableStatement?
stmt = (OracleCallableStatement) connection.prepareCall(EVOLVE_SQL);
// I tried setPlsqlIndexTable, but get the error PLS-00306: wrong number or types of arguments in call
// stmt.setPlsqlIndexTable(2, name_list, maxLen, maxLen, OracleTypes.VARCHAR, 30);
stmt.registerOutParameter(1, OracleTypes.CLOB);
stmt.execute();
dbms_spm.evolve_sql_plan_baseline(
plan_list IN DBMS_SPM.NAME_LIST,
time_limit IN INTEGER := DBMS_SPM.AUTO_LIMIT,
verify IN VARCHAR2 := 'YES',
commit IN VARCHAR2 := 'YES')
RETURN CLOB;
and for DBMS_SPM.NAME_LIST, the definition is below
Defined Data Type TYPE name_list IS TABLE OF VARCHAR2(30);