Plater, Your suggestion was brilliant. Thanks so much.
It helped me narrow down the problem to two parameters that were the cause of the issue. You would not believe, it was the name of those two parameters (3rd and 4th parameters are not named exactly as in the signature of the Stored Procedure). Oracle 10i is definitely throwing a wrong description of the error, partly to blame.
The second conclusion is also that...
kaushal30
Last Activity: Jan 5 '10, 04:03 PM
Joined: Jan 4 '10
Location:
-
kaushal30 replied to PLS-00306 Wrong number of types of arguments in call to 'Stored Procedure' {Pls help}in C SharpYes, ... Command is a System.Data.Ora cleClient.Oracl eCommand object, and the type is set to Stored procedure.Leave a comment:
-
kaushal30 started a topic PLS-00306 Wrong number of types of arguments in call to 'Stored Procedure' {Pls help}in C SharpPLS-00306 Wrong number of types of arguments in call to 'Stored Procedure' {Pls help}
I am getting this error when I call a stored procedure from my C# code. It is a simple stored procedure with six params that inserts data :
PROCEDURE LHD_SUR_ADMNEXP _HDR_INS (
p_ORG_ID Varchar,
p_YEAR Varchar,
p_DATA_NOT_APPL ICABLE_ADMNEXP Number,
p_DATA_NOT_APPL ICABLE_OPENENR Number,
P_VALDN_EXCEPN_ MSG varchar,
...
No activity results to display
Leave a comment: