Get the schema name from inside a stored-procedure
Hi,
Is it possible to get the schema name in which the stored procedure is defined from inside the stored procedure body, so that I call the stored procedure with different "current schema" but the operation is always limited to the schema the stored procedure is defined in.
e.g.
schema1 table1 and procedure1 defined in schema1 update table1.
table1 and procedure1 are CLONE-d to schema2 and schema3.
If I login as root and with schema2 to be the current database, if I call schema1.procedure1(), I want table1 in schema1 to be updated, not table1 in schema2. If I call schema3.procedure1(), I want table1 in schema3 to be updated, not table1 in schema1, neither table1 in schema2.
Thanks
Subject
Views
Written By
Posted
Get the schema name from inside a stored-procedure
4647
July 18, 2014 11:39AM
1714
July 19, 2014 09:19AM
1832
July 19, 2014 12:16PM
1909
July 20, 2014 05:45PM
1507
July 20, 2014 07:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.