Windows Oracle Data Access Components (MOSC)

MOSC Banner

Oracle ODP stored procedure & C#

edited Nov 10, 2010 5:49PM in Windows Oracle Data Access Components (MOSC) 1 commentAnswered
 We are in the process of transferring our C# application from using Microsoft Oracle connector to using ODP.

We are getting this error in our unit test.

ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 1 but only after the stored procedure has been called a number of times.  If we run each test individually they pass but if we run them all together using the same connection then the 4th or 5th call to the stored procedure fails.  The iissues seems to be data related.  It seems that oracle is creating some sort of defination of the SP arguements and caching it between calls and as a result when the parameters change sufficiently the call fails.  Any suggestions on how to track this down would be appreciated. The

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center