biztalk oracle adapter issues with oracle 12c and 19 versions

Anantha Lakshman Chilakamarri 11 Reputation points
2022-06-17T20:33:23.56+00:00

Biztalk 2016 oracle adapter is failing on oracle 19c package.
The same package in oracle 12c version works fine.

Add generated schemas option through visual studio solution file errors on oracle 19 version but no issues with the generation on oracle 12c version.

Biztalk 2016 server has oracle 12c client components installed.

Not sure anyone had similar issue.

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
376 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Anantha Lakshman Chilakamarri 11 Reputation points
    2022-06-18T01:57:32.507+00:00

    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

    1. alter session set events '10946 trace name context forever, level 65536';
    2. 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

    1 person found this answer helpful.
    0 comments No comments

  2. وحيد محمد محمود محمد 1 Reputation point
    2022-07-09T13:23:15.32+00:00
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.