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
|