Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PL/SQL numeric or value error

Nicola FarinaOct 14 2008 — edited Oct 15 2008
Hello all,

I have this error at the customer's site, after deploying my application.
The stored procedure called is something like:

OracleCommand cmd = new OracleCommand(
"begin \n" +
ApplicationSchema + ".IAccessOra.GetFormScript(:IdForm, :DdScript, :Azione, 1); \n " +
"end;", MainSession);
cmd.CommandType = CommandType.Text;
cmd.BindByName = true;
cmd.Parameters.Add("IdForm", OracleDbType.Decimal, IdForm, ParameterDirection.Input);
cmd.Parameters.Add("DdScript", OracleDbType.Clob, 32000, DBNull.Value, ParameterDirection.Output);
cmd.Parameters.Add("Azione", OracleDbType.Varchar2, 10, GlobalMembers.cScriptEventId[(int)Evento], ParameterDirection.Input);

It seems the situation of bug 4015165, but the error is systematic, not intermittent.
But when I tried to build a test case I failed. The same function which fails in the main project, works or has intermittent errors when set aside in another project.
In office everything works.

Environment:

customer:
database 9206 client 10.2.0.4 win 2003 R2 standard sp 2 (virtual with vmware)

office
database 9207 client 10.2.0.4 and odp.net 11 win 2003 R2 standard sp 2 (virtual with vmware)

In office I have never seen this error, and I have 9207, so
I asked the customer to patch his database to 9207 or 9208.

Is this advice reasonable in your opinion ?

Btw I tried to enable odp.net trace at the customer site but it doesn't generate the trace file. Could it depend on the fact that the server
is virtual ?

Thanks for any idea/advice/tip
Bye
Nicola

Comments

I'm also facing same issue

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 12 2008
Added on Oct 14 2008
5 comments
822 views