kofolamaster
Member²
When copying package->procedure using CTRL+C from object browser browsing other schemas the copied name is schema.procedure_name instead of schema.package_name.procedure_name.
This does not happen when copying from owned packages - the name is only procedure_name instead of package.procedure_name
test case:
- lets have schemas A and B
- let B have package C with public procedure D granted EXECUTE to A
- now log in to schema A and find the procedure D (find package C in the browser window; expand the package; expand procedures subitem)
- select D from procedures subitem list
- hit CTRL+C to copy its name
- the clipboard now contains 'B.D' instead of 'B.C.D'
This does not happen when copying from owned packages - the name is only procedure_name instead of package.procedure_name
test case:
- lets have schemas A and B
- let B have package C with public procedure D granted EXECUTE to A
- now log in to schema A and find the procedure D (find package C in the browser window; expand the package; expand procedures subitem)
- select D from procedures subitem list
- hit CTRL+C to copy its name
- the clipboard now contains 'B.D' instead of 'B.C.D'