sql object_id() 对应oracle,Regarding PLSQL_OBJECT_ID

Hi,

DOCs could reveal some more interesting details. Here is what I understand:

plssql_entry_object_id is the top level PL/SQL-Object currently invoked by this session

plsql_object_id is the currently executing PL/SQL-Object from this session

And here you will see how to get this objects:

SELECT sid

, serial#

, username

, ( SELECT max( substr( sql_text , 1, 40 )) FROM v$sql sq WHERE sq.sql_id = se.sql_id ) AS sql_text

, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = 0) AS plsql_entry_object

, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = plsql_entry_subprogram_id) AS plsql_entry_subprogram

, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = 0) AS plsql_entry_object

, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = PLSQL_SUBPROGRAM_ID) AS plsql_entry_subprogram

, se.*

FROM v$session se

WHERE 1=1

-- AND se.status = 'ACTIVE'

-- AND sid = 397

-- AND plsql_entry_object_id IS NOT NULL

ORDER BY se.sidRegards

Martin