Table of Contents
This chapter briefly introduces the OWA_UTIL package, and describes how to use the procedure of the package.
This section describes the procedure provided by the OWA_UTIL package
Gets information about which object calls the object.
Details about the WHO_CALLED_ME procedure are as follows.
Prototype
PROCEDURE WHO_CALLED_ME
(
owner OUT VARCHAR2,
name OUT VARCHAR2,
lineno OUT NUMBER,
caller_t OUT VARCHAR2)
);
Parameter
| Parameter | Description |
|---|---|
| owner | Calling object owner. |
| name | Calling object name. |
| lineno | Line number within the calling object where the call was made. |
| caller_t | Calling object type. |
Example
create or replace procedure OWA_PROC1
as
v1 varchar(128);
v2 varchar(128);
v3 number;
v4 varchar(128);
begin
owa_util.who_called_me (v1, v2, v3, v4);
dbms_output.put_line (v1);
dbms_output.put_line (v2);
dbms_output.put_line (v3);
dbms_output.put_line (v4);
end;
/
create or replace procedure OWA_PROC2
as
begin
OWA_PROC1;
end;
/
begin
OWA_PROC1;
end;
/
--2
--ANONYMOUS BLOCK
begin
OWA_PROC2;
end;
/
--TIBERO
--OWA_PROC2
--4
--PROCEDURE