DB2 / ADO Stored Procedure Help
I'm new to DB2 and am having trouble calling stored procedures. When ever
I call one, I get the following error:
NO PROCEDURE BY THE NAME XXX HAVING COMPATIBLE ARGUMENTS WAS FOUND.
The XXX is what ever stored procedure I am trying to run. I've checked that
the SP name and parameters are valid. Anyone have any ideas of what I could
check?
Thanks!
[399 byte] By [
Jeff Beck] at [2007-11-9 18:52:02]
# 1 Re: DB2 / ADO Stored Procedure Help
Try DBO.XXX, or whatever the Schema the Stored Procedure was created under.
Just a Thought.
KlK, MCSE
"Jeff Beck" <jbeck@dpai.com> wrote:
>
>I'm new to DB2 and am having trouble calling stored procedures. When ever
>I call one, I get the following error:
>
>NO PROCEDURE BY THE NAME XXX HAVING COMPATIBLE ARGUMENTS WAS FOUND.
>
>The XXX is what ever stored procedure I am trying to run. I've checked
that
>the SP name and parameters are valid. Anyone have any ideas of what I could
>check?
>
>Thanks!
# 2 Re: DB2 / ADO Stored Procedure Help
Well I found another thing that causes this, quality IBM code. Verify that
you are passing the same number of parameters as the Stored Proc is expecting.
Don't use SMALLINT
If you define a field as DECIMAL (9, 2), better pass 9 digits plus the decimal
point. i.e. All leading zeros.
"kevin knudson" <klk@knudsons.com> wrote:
>
>Try DBO.XXX, or whatever the Schema the Stored Procedure was created under.
>
>Just a Thought.
>
>KlK, MCSE
>
>
>"Jeff Beck" <jbeck@dpai.com> wrote:
>>
>>I'm new to DB2 and am having trouble calling stored procedures. When ever
>>I call one, I get the following error:
>>
>>NO PROCEDURE BY THE NAME XXX HAVING COMPATIBLE ARGUMENTS WAS FOUND.
>>
>>The XXX is what ever stored procedure I am trying to run. I've checked
>that
>>the SP name and parameters are valid. Anyone have any ideas of what I
could
>>check?
>>
>>Thanks!
>
# 3 Re: DB2 / ADO Stored Procedure Help
Try qualifying the stored proc name with the schema name ie. say the stored
proc was created as db2admin.xxx then the command_text = "db2admin.xxx"
It should work else let me know
Praveen
"Jeff Beck" <jbeck@dpai.com> wrote:
>
>I'm new to DB2 and am having trouble calling stored procedures. When ever
>I call one, I get the following error:
>
>NO PROCEDURE BY THE NAME XXX HAVING COMPATIBLE ARGUMENTS WAS FOUND.
>
>The XXX is what ever stored procedure I am trying to run. I've checked
that
>the SP name and parameters are valid. Anyone have any ideas of what I could
>check?
>
>Thanks!
