Search Results get_blob_arg

Overview

SYS.DBMS_DEFER_QUERY is a core Oracle-supplied PL/SQL package that belongs to the standard deferred remote procedure call (deferred RPC) infrastructure used by Oracle's symmetric replication and advanced replication features. It is owned by the SYS schema and reported as VALID in both Oracle E-Business Suite 12.1.1 and 12.2.2 environments. Within the EBS technology stack, the package abstracts the storage and retrieval of deferred transaction arguments, providing callers with a uniform, type-aware interface for extracting individual arguments from deferred call queue rows that Oracle records in the DEF$_CALL and DEF$_ARGUMENT tables and their REPCAT$_* counterparts.

The package is classified in ETRM as OTHER API, meaning it is not an EBS business API exposed for customer extension, but rather an internal Oracle database utility surfaced through public synonyms. It depends on SYS.ANYDATA, STANDARD, and SYSTEM.REPCAT$_OBJECT_NULL_VECTOR, and it is referenced by eight other packages including DBMS_DEFER, DBMS_DEFER_INTERNAL_QUERY, DBMS_DEFER_QUERY_DEFINER, DBMS_DEFERGEN_WRAP, and DBMS_DEFER_SYS_PART1.

Key Procedures and Functions

The ETRM documentation records twenty-six procedures and functions in the package. The largest group are typed argument accessors that return a specific argument from a deferred call by ordinal position, preserving the original datatype:

• GET_NUMBER_ARG, GET_VARCHAR2_ARG, GET_NVARCHAR2_ARG, GET_CHAR_ARG, GET_NCHAR_ARG — retrieve scalar character and numeric arguments.
• GET_DATE_ARG, GET_TIME_ARG, GET_TIMESTAMP_ARG — retrieve date and time arguments, including the newer datetime types.
• GET_TTZ_ARG, GET_TSTZ_ARG, GET_TSLTZ_ARG, GET_IYM_ARG — retrieve time-zone-aware timestamps and interval year-to-month arguments.
• GET_RAW_ARG, GET_ROWID_ARG, GET_BLOB_ARG, GET_CLOB_ARG, GET_NCLOB_ARG — retrieve LOB and binary arguments.
• GET_ARG_TYPE, GET_ARG_CSETID, GET_ARG_FORM — describe an argument's datatype, character set identifier, and encoding form, allowing callers to choose the correct typed getter.

These accessors are the documented public surface; the package body also contains internal helpers used by the deferred RPC engine.

Tables Accessed

The ETRM excerpt does not enumerate specific base tables via APPS synonyms, which is expected because the package operates against SYS-owned replication catalog objects. In practice, DBMS_DEFER_QUERY reads argument metadata from the deferred transaction catalog (the DEF$_ARGUMENT, DEF$_CALL, and REPCAT$_OBJECT_NULL_VECTOR structures) and returns the decoded value to the caller. It performs no writes to EBS application tables.

Usage Notes

DBMS_DEFER_QUERY is not invoked directly by EBS forms or concurrent programs. It is called by the replication engine and by sibling packages such as DBMS_DEFER when a deferred transaction is pushed, purged, or replayed between master sites. EBS customers encounter it only when auditing deferred RPC errors in DEF$_ERROR, troubleshooting advanced replication, or writing diagnostic code that inspects queued calls. Custom code should use the public synonym that resolves to SYS.DBMS_DEFER_QUERY and should not depend on undocumented internals.