467,915 Members | 1,527 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

Error in calling remote nested SP

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

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,
Sep 17 '07 #1
  • viewed: 1203

Post your reply

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

Similar topics

1 post views Thread by Wayno | last post: by
7 posts views Thread by Jorgen Haukland, Norway | last post: by
8 posts views Thread by =?Utf-8?B?U3JpcmFtIE1hbGxhanlvc3VsYQ==?= | last post: by
12 posts views Thread by kirara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.