By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Error in calling remote nested SP

P: 2
Hi All,

I am facing an error when I try to invoke a remote nested stored proc. Please find the details below.

1) SP TEST1 is defined in DB2 instance DB2A. It is calling a stored procedure
REMOTE1 which is defined in another instance DB2B.
2) Before actually calling REMOTE1, the calling stored procedure is connecting
to DB2B instance using connect statement and the remote storedprocedure
is called with the name 'SYSPROC.REMOTE1'
3) I created a package in DB2A and in DB2B for the stored procedure TEST1.
4) I am not sure whether #3 is correct, but it rectified my first error namely -805.
5) However, when I execute TEST1, I am getting -440 error.

-440 NO routine-type BY THE NAME routine-name HAVING COMPATIBLE
ARGUMENTS WAS FOUND

I am comparitively new to stored procedures and I believe the error is because of incorrect binding. Could anyone please suggest some solution?

Thanks for your time,
Aravind
Sep 17 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.