As of BDE 5.1.0, Developer Support has seen a number of conditions where a Stored Proc is created correctly inside of a package, yet it will not operate correctly. This problem was introduced in version 5.1.0 as a result of fixing a bug where you crashed loading params for a stored proc with greater than 10 parameters. The conditions where this problem occur are:
As of this time we don't have an exact description for what Stored Procedures work and which one do not. However; our observation is that most work. For those that have this problem, the workaround is to move the Stored Procedure out of a package and into a standalone Stored Procedure.
As of this time we believe this problem to be in the Oracle client. It is possible a future version of the Oracle client may resolve the problem.
Last Modified: 24-OCT-00