This function returns TRUE if an object name exists and is viewable.
FUNCTION RESIDENT
(
PROCNAME VARCHAR2
)
RETURN PL/SQL BOOLEAN;
| Parameter | Description |
|---|---|
procname |
The object name to interrogate. |
TRUE if the object exists; FALSE otherwise.
The following example illustrates how to call resident.
begin
if http.resident('P') then
execute immediate 'P';
end if;
end;