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 INdatatype
)
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 ... |
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.