Is there a way to retrieve schema owner of a store procedure from within its implementation?
The stored procs are
. When the stored procedure gets executed, I need to retrieve name of the schema to perform some schema level tasks and also lookup objects (tables, columns, etc.) in that schema.
but it returns the default schema of the logged in user (which is
) not the schema owner of the stored procedure.
How do I get the schema of the executing stored procedure?