jdbc adapter not updated after deployment when using stored procedure with signature

, ,
1

Hi guys, I have a very weird problem with jdbc adapter, when ever I select stored procedure with signature template and using the current schema which is the same in data base connection configuration, it works fine in dev but after I deploy it, it dosent work, gives me a error saying stored procedure is null, but if i change the schema to the user form current, it works fine, the problem is I should always change it in all the production servers after deployment whichi I think is not good, any ideas?

Thanks:proud:

2

seems to be a privilege issue on database side, i think same user dont have privilege to procedure on the test env