Hello,
Somebody know if it's possible to get the name of the schema that is calling a procedure hosted in another schema ?
I'm using SYS_CONTEXT('USERENV','CURRENT_SCHEMA') in a procedure to get the name of the "Calling" schema, but it always return the name of the schema that host the procedure, not the name of the schema that is calling it.
Is there a way to get the name of the "Calling" schema ?