JTF_USR_HKS became invalid after having Upgraded database from 10gR2 to 11gR2 on an 11i installation
Hi,
Applied patch 5454655 to fix the object but the object JTF_USR_HKS continues to be invalid:
SQL> alter package apps.JTF_USR_HKS compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors;
Errors for PACKAGE BODY APPS.JTF_USR_HKS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
940/5 PL/SQL: Statement ignored
940/5 PLS-00306: wrong number or types of arguments in call to
'SETROWSETTAG'
941/4 PL/SQL: Statement ignored
941/4 PLS-00306: wrong number or types of arguments in call to
'SETMETAHEADER'
942/4 PL/SQL: Statement ignored
942/4 PLS-00306: wrong number or types of arguments in call to
'SETDATAHEADER'
LINE/COL ERROR
-------- -----------------------------------------------------------------
964/6 PL/SQL: Statement ignored