Apparently biztalk 2016 and Oracle 19c have compatibility issues. Hence the oracle adapter will fail with oracle 19c related packages/procedures.
Workaround:
Run following script in oracle instance
- alter session set events '10946 trace name context forever, level 65536';
- alter package <package_name> compile;
Following links have detailed description and the fix.
https://learn.microsoft.com/en-us/answers/questions/464806/biztalk-2016-and-oracle-19c.html
https://stackoverflow.com/questions/58434047/biztalk-unable-to-read-oracle-18-stored-procedure-with-strongly-typed-ref-cursor