v-wywang
8/23/2007 10:56:00 AM
Hello Dave,
Thanks for your wait.
I have reproduced this issue on my side. It seems a product limitation.
However, I figured out a work around: removing "Execute/Call" from SQL
command and setting CommandType to StoredProcedure.
ocd.CommandText = "test.ins_test(8,'pp')";
ocd.CommandType = System.Data.CommandType.StoredProcedure;
ocd.ExecuteNonQuery();
Would you please try the above method and let me know if it works for you?
For the second issue, I suggest we follow the steps as below to trouble
shoot:
1) Check if PL/SQL "execute ADD_JOB_HISTORY ()" works correctly within
Oracle SQL*Plus.
2) If this stored procedure works fine with Oracle SQL*Plus, we need to
hard-code values for parameters and execute it as StroredProcedure.
cmd.CommandText = String.Format("ADD_JOB_HISTORY({0},{1},{2},{3},{4})",
123,
DateTime.Now.AddMonths(-1).Date,
DateTime.Now.Date,
"SA_MAN",
10);
cmd.CommandType = CommandType.StoredProcedure;
If all these steps work fine on your side, would you please send me your
Stored Procedure? Thereby I could reproduce the issue and perform further
analyze.
I'm waiting for you reply. Have a great day. thanks.
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.