Oracle Distributed Systems

Name

DBMS_DEFER.datatype_ARG

Synopsis

This datatype_ARG procedure specifies an argument for a procedure being built for a remote procedure call. The argument is of the datatype specified in datatype.

PROCEDURE DBMS_DEFER.datatype_ARG (arg IN datatype)

Parameters

Specifications differ for different datatypes, depending on whether you are using Oracle7 or Oracle8. datatype can be any type in the following table.

Oracle7 and Oracle8	Oracle8 Only
NUMBER	NVARCHAR2
DATE	ANY_VARCHAR2
VARCHAR2	NCHAR
CHAR	ANY_VARCHAR
ROWID	BLOB
RAW	CLOB
ANY_CLOB
NCLOB

The arg parameter is the value to pass to the parameter of the same datatype in the procedure previously queued via CALL; it may not exceed the following:

• 2000 for CHAR and VARCHAR2

• 255 for RAW

The various alternatives are listed here.

These specifications apply to both Oracle7 and Oracle8:

PROCEDURE NUMBER_ARG (arg IN NUMBER);
PROCEDURE DATE_ARG (arg IN DATE);
PROCEDURE VARCHAR2_ARG (arg IN VARCHAR2);
PROCEDURE CHAR_ARG (arg IN CHAR);
PROCEDURE ROWID_ARG (arg IN ROWID);
PROCEDURE RAW_ARG (arg IN RAW);

These specifications apply only to Oracle8:

PROCEDURE NVARCHAR2_ARG (arg IN NVARCHAR2);
PROCEDURE ANY_VARCHAR2_ARG (arg  IN VARCHAR2 CHARACTER SET ANY_CS);
PROCEDURE NCHAR_ARG (arg IN NCHAR);
PROCEDURE ANY_CHAR_ARG (arg IN CHAR CHARACTER SET ANY_CS);
PROCEDURE BLOB_ARG (arg IN BLOB);
PROCEDURE CLOB_ARG (arg IN CLOB);
PROCEDURE ANY_CLOB_ARG (arg IN CLOB CHARACTER SET ANY_CS);
PROCEDURE NCLOB_ARG (arg IN NCLOB);

Exceptions

Exception Name	Number	Description
paramlen_num	–23323	Parameter ...