My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle Data Provider for .NET - Version and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)Symptoms

You have an Oracle Applications environment (for example, 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().


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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