Change to create_stored_proc_call()
Brought to you by:
skuchin
create_stored_proc_call() is used to automatically
determine the arguments for a specified stored proc.
However, the existing name resolution for the stored
proc. is limited to current user or specified owner.
This patch, modifies the sql used to determine the
arguments by doing a more thorough name resolution of
the sp when the owner is not specified. It follows
standard Oracle name resolution by looking at:
- sp in current user
- private synonym for sp
- public synonym for sp
The patch is against the vanilla 4.0.113 version of
otlv4.h.
The patch was created by doing a "diff -c5 <original>
<patched> > <patchfile>"
The patch can be applied by doing a "patch -c <
<patchfile>"
Patch to create_stored_proc_call() in 4.0.113