upgrade database from 11.2.0.4 to 19.21ORA-25215: user_data type and queue type do not match
1 We upgrade database from 11.2.0.4 to 19.21 again, after upgrade database, WF_DEFERRED_QUEUE_M_R become INVALID
2 we following : Fixing Invalid Workflow Rule Sets such as WF_DEFERRED_R and Related Errors on Workflow Queues:ORA-24033 ( Doc ID 337294.1 )
to fix , but WF_DEFERRED_QUEUE_M_R also is INVALID
3 and now ,we run following scripts get error ORA-25215: user_data type and queue type do not match:
SQL> begin
2 adx_prf_pkg.set_profile(174, 'ECX_UTL_XSLT_DIR',
3 10001, 0,
4 '/appl/DEV2/temp/DEV2',
5 NULL, 'DEV2_erpdb02');
6 end;
7 /
begin
*
ERROR at line 1:
ORA-25215: user_data type and queue type do not match