在 Oracle PL/SQL 中获取调用过程或函数的名称
有谁知道 PL/SQL 过程(在本例中为错误记录过程)是否有可能获得调用它的函数/过程的名称?
Does anyone know whether it's possible for a PL/SQL procedure (an error-logging one in this case) to get the name of the function/procedure which called it?
显然我可以将名称作为参数传入，但是进行系统调用或其他方式来获取信息会很好-如果不是从过程/函数中调用，它可以只返回 null 或其他内容.
Obviously I could pass the name in as a parameter, but it'd be nice to make a system call or something to get the info - it could just return null or something if it wasn't called from a procedure/function.
如果没有这方面的方法，那很好 - 只是好奇是否有可能(搜索一无所获).
If there's no method for this that's fine - just curious if it's possible (searches yield nothing).
推荐答案
有一个名为 OWA_UTIL 的包(在旧版本的数据库中默认不安装).这有一个方法 WHO_CALLED_ME() 返回 OWNER、OBJECT_NAME、LINE_NO 和 CALLER_TYPE.请注意，如果调用者是一个打包过程，它将返回 PACKAGE 名称而不是过程名称.在这种情况下，无法获得过程名称；这是因为过程名可以重载，所以不一定很有用.
There is a package called OWA_UTIL (which is not installed by default in older versions of the database). This has a method WHO_CALLED_ME() which returns the OWNER, OBJECT_NAME, LINE_NO and CALLER_TYPE. Note that if the caller is a packaged procedure it will return the PACKAGE name not the procedure name. In this case there is no way of getting the procedure name; this is because the procedure name can be overloaded, so it's not necessarily very useful.
了解更多信息.
从 10gR2 开始，还有 $$PLSQL_UNIT 特殊功能；这也将返回 OBJECT NAME(即包不是打包过程).
Since 10gR2 there is also the $$PLSQL_UNIT special function; this will also return the OBJECT NAME (i.e. package not packaged procedure).
相关文章