Using ODP.NET To Call Oracle Apps Stored Procedures Results In Unexpected Behavior On Second Call (Doc ID 1351984.1)

You have an Oracle Applications environment (for example, 11.5.10.1) and you want to call a stored procedure that interacts with this environment.

When calling the stored procedure from SQL*Plus it works each time you call it.

When calling the same stored procedure from a .NET application using the Oracle Data Provider for .NET (ODP.NET) it works the first time and fails on all subsequent calls.

The stored procedure you are calling may be making a call to FND_GLOBAL.APPS_INITIALIZE().

Changes

This behavior may have always existed, or you may have applied an Oracle Applications patch (for example, ATG.RUP5) that has caused the change in behavior.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.