eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DEFCALL

Object Details

Object Name:	DEFCALL
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information about all deferred remote procedure calls

[View Source]

Columns

Name	Datatype	Length	Comments
CALLNO	NUMBER		Unique ID, orders calls within a transaction
DEFERRED_TRAN_ID	VARCHAR2	(30)	The unique ID of the associated transaction
SCHEMANAME	VARCHAR2	(30)	The schema name of the deferred call
PACKAGENAME	VARCHAR2	(30)	The package name of the deferred call
PROCNAME	VARCHAR2	(30)	The procedure name of the deferred call
ARGCOUNT	NUMBER		The number of arguments to the deferred procedure call

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CALLNO
,      DEFERRED_TRAN_ID
,      SCHEMANAME
,      PACKAGENAME
,      PROCNAME
,      ARGCOUNT
FROM SYS.DEFCALL;

Dependencies

[top of page]

SYS.DEFCALL references the following:

SYS: DBMS_DEFER_QUERY_UTL - show dependent code
SYSTEM: DEF$_AQCALL; DEF$_AQERROR

SYS.DEFCALL is referenced by following:

PUBLIC: DEFCALL
SYS: DBMS_DEFER_SYS_PART1 - show dependent code