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

Remote database access within MB flow

P: 2
hi,

Iam having a message flow within which iam calling the stored procedure which is remotely maintained.
I have connected to the remote database through my DB2 and tested the connection successfully.
But when I deployed and executed my Message flow at the point of calling the stored procedure it is giving an excepiton.
The exception is "The Procedure is unknown to the database and no definition could be found"
But the procedure is existing and is working fine when we test it independently on the local system.
Can anybody help me out in this matter.

Thanks in Advance
Sep 24 '07 #1
Share this Question
Share on Google+
1 Reply


P: 2
is the schema name and the user id need to be same?? can u plz help me by giving the sample. The ODBC name, procedure everything s proper..

can anyone plz provide me a sample call statement syntax for calling external stored procedure while using remote db2.
Sep 24 '07 #2

Post your reply

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