I have a stored proc called PROC5. It is in a schema named SCHEMAX.
I have a user connecting from a java program. This user has a config files that sets the schema name to SCHEMAY. I would like this user to run my stored proc5, but I don't want to tell him to use SCHEMAY for his queries but SCHEMAX for calls.
Is there a way to allow users to refer to my stored procedure as SCHEMAY.PROC5, and having it actually point to the stored proc I created in SCHEMAX? If not, can someone think of a way to accomplish this without having to maintain two separate copies of my stored proc?