I have a created a procedure in schema1 and it has parameters that need to be supplied to it. Then I created a synonym called appl.procname pointing to schema1.procname. When I try to execute the appl.procname 'para' it failed with the following message :
Procedure or function procname' expects parameter '@userId', which was not supplied. I can run the procdure using the schema1.procname and supply the paramter. Any help would be greatly appreciated.
thanks