在 Oracle PL/SQL 中获取调用过程或函数的名称 [英] Get the name of the calling procedure or function in 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).

这篇关于在 Oracle PL/SQL 中获取调用过程或函数的名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！