Oracle Parameter goes missing

[Guest]

I have stored proc that takes 5 parameters and works fine when called from within one class, in another class i ge
"ORA-06550: line 1, column 7
PLS-00306: wrong number or types of arguments in call to 'GETPEOPLE
ORA-06550: line 1, column 7
PL/SQL: Statement ignored
when looking with QuickWatch at the Command object its Parameters collection has all the parameters set up correctly BU
StatementText for the Command object is:
StatementText "begin PDCProcedures.GetPeople(p_LinkPersonID=>_LinkPersonID, p_PersonID=>_PersonID, p_Result=>_Result, p_ErrorMessage=>_ErrorMessage); end;" Strin

ie it only has 4 parameters rather than 5, the middle one is missing

Microsoft Oracle DataProvider, VB.NET 2002, Win2K, Oracle Server V8.174, Oracle Client 9.2.0.1.
any ideas

gu

 

[Guest]

the value for the middle (input) parameter was not set -doh!

 

[David Browne]

I have stored proc that takes 5 parameters and works fine when called

from within one class, in another class i get

"ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETPEOPLE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"
when looking with QuickWatch at the Command object its Parameters

collection has all the parameters set up correctly BUT

StatementText for the Command object is:-
StatementText "begin

PDCProcedures.GetPeople(p_LinkPersonID=>_LinkPersonID,
p_PersonID=>_PersonID, p_Result=>_Result,
p_ErrorMessage=>_ErrorMessage); end;" String

ie it only has 4 parameters rather than 5, the middle one is missing!

Microsoft Oracle DataProvider, VB.NET 2002, Win2K, Oracle Server V8.174, Oracle Client 9.2.0.1.0
any ideas?

No. But I know how you can fix it.

Just don't use CommandType.StoredProcedure. Use CommandType.Text and set
the command's text to the correct PL/SQL block to invoke the procedure.

EG

@"
begin
PDCProcedures.GetPeople(p_LinkPersonID=>_LinkPersonID,
p_PersonID=>_PersonID,
p_Whatever=>_Whatever,
Result=>_Result,
p_ErrorMessage=>_ErrorMessage);
end;
"

Then bind your parameters.

David