Objects and Arguments for Package PLJSON_EXT
Object Name Overload Argument Name Position Datatype Direction
BASE64 1 BINARYDATA 1 BLOB IN
BASE64 1 <return value for function>   OBJECT OUT
BASE64 2 L 1 OBJECT IN
BASE64 2 <return value for function>   BLOB OUT
BLOB2CLOB   B 1 BLOB IN
BLOB2CLOB   C 2 CLOB OUT
BLOB2CLOB   CHARSET 3 VARCHAR2 IN
DECODE   V 1 OBJECT IN
DECODE   <return value for function>   BLOB OUT
DECODEBASE64CLOB2BLOB   P_CLOB 1 CLOB IN
DECODEBASE64CLOB2BLOB   <return value for function>   BLOB OUT
ENCODE   BINARYDATA 1 BLOB IN
ENCODE   <return value for function>   OBJECT OUT
ENCODEBASE64BLOB2CLOB   P_BLOB 1 BLOB IN
ENCODEBASE64BLOB2CLOB   <return value for function>   CLOB OUT
GET_BOOL   OBJ 1 OBJECT IN
GET_BOOL   PATH 2 VARCHAR2 IN
GET_BOOL   BASE 3 NUMBER IN
GET_BOOL   <return value for function>   PL/SQL BOOLEAN OUT
GET_DATE   OBJ 1 OBJECT IN
GET_DATE   PATH 2 VARCHAR2 IN
GET_DATE   BASE 3 NUMBER IN
GET_DATE   <return value for function>   DATE OUT
GET_DOUBLE   OBJ 1 OBJECT IN
GET_DOUBLE   PATH 2 VARCHAR2 IN
GET_DOUBLE   BASE 3 NUMBER IN
GET_DOUBLE   <return value for function>   BINARY_DOUBLE OUT
GET_JSON   OBJ 1 OBJECT IN
GET_JSON   PATH 2 VARCHAR2 IN
GET_JSON   BASE 3 NUMBER IN
GET_JSON   <return value for function>   OBJECT OUT
GET_JSON_LIST   OBJ 1 OBJECT IN
GET_JSON_LIST   PATH 2 VARCHAR2 IN
GET_JSON_LIST   BASE 3 NUMBER IN
GET_JSON_LIST   <return value for function>   OBJECT OUT
GET_JSON_VALUE   OBJ 1 OBJECT IN
GET_JSON_VALUE   V_PATH 2 VARCHAR2 IN
GET_JSON_VALUE   BASE 3 NUMBER IN
GET_JSON_VALUE   <return value for function>   OBJECT OUT
GET_NUMBER   OBJ 1 OBJECT IN
GET_NUMBER   PATH 2 VARCHAR2 IN
GET_NUMBER   BASE 3 NUMBER IN
GET_NUMBER   <return value for function>   NUMBER OUT
GET_STRING   OBJ 1 OBJECT IN
GET_STRING   PATH 2 VARCHAR2 IN
GET_STRING   BASE 3 NUMBER IN
GET_STRING   <return value for function>   VARCHAR2 OUT
IS_DATE   V 1 OBJECT IN
IS_DATE   <return value for function>   PL/SQL BOOLEAN OUT
IS_INTEGER   V 1 OBJECT IN
IS_INTEGER   <return value for function>   PL/SQL BOOLEAN OUT
PARSEPATH   JSON_PATH 1 VARCHAR2 IN
PARSEPATH   BASE 2 NUMBER IN
PARSEPATH   <return value for function>   OBJECT OUT
PP 1 OBJ 1 OBJECT IN
PP 1 V_PATH 2 VARCHAR2 IN
PP 1 <return value for function>   VARCHAR2 OUT
PP 2 OBJ 1 OBJECT IN
PP 2 V_PATH 2 VARCHAR2 IN
PP_HTP   OBJ 1 OBJECT IN
PP_HTP   V_PATH 2 VARCHAR2 IN
PUT 1 OBJ 1 OBJECT IN/OUT
PUT 1 PATH 2 VARCHAR2 IN
PUT 1 ELEM 3 VARCHAR2 IN
PUT 1 BASE 4 NUMBER IN
PUT 2 OBJ 1 OBJECT IN/OUT
PUT 2 PATH 2 VARCHAR2 IN
PUT 2 ELEM 3 NUMBER IN
PUT 2 BASE 4 NUMBER IN
PUT 3 OBJ 1 OBJECT IN/OUT
PUT 3 PATH 2 VARCHAR2 IN
PUT 3 ELEM 3 BINARY_DOUBLE IN
PUT 3 BASE 4 NUMBER IN
PUT 4 OBJ 1 OBJECT IN/OUT
PUT 4 PATH 2 VARCHAR2 IN
PUT 4 ELEM 3 OBJECT IN
PUT 4 BASE 4 NUMBER IN
PUT 5 OBJ 1 OBJECT IN/OUT
PUT 5 PATH 2 VARCHAR2 IN
PUT 5 ELEM 3 OBJECT IN
PUT 5 BASE 4 NUMBER IN
PUT 6 OBJ 1 OBJECT IN/OUT
PUT 6 PATH 2 VARCHAR2 IN
PUT 6 ELEM 3 PL/SQL BOOLEAN IN
PUT 6 BASE 4 NUMBER IN
PUT 7 OBJ 1 OBJECT IN/OUT
PUT 7 PATH 2 VARCHAR2 IN
PUT 7 ELEM 3 OBJECT IN
PUT 7 BASE 4 NUMBER IN
PUT 8 OBJ 1 OBJECT IN/OUT
PUT 8 PATH 2 VARCHAR2 IN
PUT 8 ELEM 3 DATE IN
PUT 8 BASE 4 NUMBER IN
REMOVE   OBJ 1 OBJECT IN/OUT
REMOVE   PATH 2 VARCHAR2 IN
REMOVE   BASE 3 NUMBER IN
TO_DATE   V 1 OBJECT IN
TO_DATE   <return value for function>   DATE OUT
TO_DATE2   V 1 OBJECT IN
TO_DATE2   <return value for function>   DATE OUT
TO_JSON_VALUE   D 1 DATE IN
TO_JSON_VALUE   <return value for function>   OBJECT OUT