Oracle | DBMS

Oracle DBMS_CLR Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented but related to the use of .NET extensions in Oracle Database's installed and running on Microsoft Windows.

This package has been found installed in 11gR2, in 12.1.0.1 but not installed by default, installed by default in 12.1.0.2, and since then uninstalled in every version through 21c. Reference is also found to this package in $ORACLE_HOME/rdbms/admin/catcdb.pl where it is identified as "Net Extensions."

AUTHID CURRENT_USER

Dependencies

ALL_LIBRARIES	NLS_DATABASE_PARAMETERS	PLITBLM
DBMS_CLRPARAMTABLE	ORACLECLR_LIB	XMLTYPE
DBMS_CLRTYPE

Documented No

First Available 11gR2

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsclr.plb

In 21c it is essential that you read dbmsclr_drop.sql.

Subprograms

CLEARPARAMETERS	EXECUTEXMLTYPEFUNCTION	GETXMLTYPEPARAMVALUE
EXECUTEBFILEFUNCTION	GETBFILEPARAMVALUE	SETBFILEPARAM
EXECUTEBLOBFUNCTION	GETBLOBPARAMVALUE	SETBLOBPARAM
EXECUTECHARFUNCTION	GETCHARPARAMVALUE	SETCHARPARAM
EXECUTECLOBFUNCTION	GETCLOBPARAMVALUE	SETCLOBPARAM
EXECUTEDATEFUNCTION	GETDATEPARAMVALUE	SETDATEPARAM
EXECUTEDOUBLEFUNCTION	GETDBMSCLRVERSION	SETDOUBLEPARAM
EXECUTEFLOATFUNCTION	GETDOUBLEPARAMVALUE	SETFLOATPARAM
EXECUTEINTERVALDSFUNCTION	GETFLOATPARAMVALUE	SETINTERVALDSPARAM
EXECUTEINTERVALYMFUNCTION	GETINTERVALDSPARAMVALUE	SETINTERVALYMPARAM
EXECUTEINTFUNCTION	GETINTERVALYMPARAMVALUE	SETINTPARAM
EXECUTELONGFUNCTION	GETINTPARAMVALUE	SETLONGPARAM
EXECUTELONGRAWFUNCTION	GETLONGPARAMVALUE	SETLONGRAWPARAM
EXECUTENCHARFUNCTION	GETLONGRAWPARAMVALUE	SETNCHARPARAM
EXECUTENCLOBFUNCTION	GETNCHARPARAMVALUE	SETNCLOBPARAM
EXECUTENUMBERFUNCTION	GETNCLOBPARAMVALUE	SETNUMBERPARAM
EXECUTENVARCHARFUNCTION	GETNUMBERPARAMVALUE	SETNVARCHARPARAM
EXECUTEPROCEDURE	GETNVARCHARPARAMVALUE	SETRAWPARAM
EXECUTERAWFUNCTION	GETRAWPARAMVALUE	SETROWIDPARAM
EXECUTEROWIDFUNCTION	GETROWIDPARAMVALUE	SETTIMESTAMPLTZPARAM
EXECUTETIMESTAMPFUNCTION	GETTIMESTAMPLTZPARAMVALUE	SETTIMESTAMPPARAM
EXECUTETIMESTAMPLTZFUNCTION	GETTIMESTAMPPARAMVALUE	SETTIMESTAMPTZPARAM
EXECUTETIMESTAMPTZFUNCTION	GETTIMESTAMPTZPARAMVALUE	SETVARCHARPARAM
EXECUTEVARCHARFUNCTION	GETVARCHARPARAMVALUE	SETXMLTYPEPARAM

CLEARPARAMETERS

Undocumented dbms_clr.clearParameters;

exec dbms_clr.clearParameters;

      

      PL/SQL procedure successfully completed.

EXECUTEBFILEFUNCTION

Undocumented dbms_clr.executeBFilefunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN BFILE;

TBD

EXECUTEBLOBFUNCTION

Undocumented dbms_clr.executeBlobfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN BLOB;

TBD

EXECUTECHARFUNCTION

Undocumented dbms_clr.executeCharfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN DATE;

TBD

EXECUTECLOBFUNCTION

Undocumented dbms_clr.executeClobfunction( dbms_clr.executeClobFunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN CLOB;

TBD

EXECUTEDATEFUNCTION

Undocumented dbms_clr.executeDatefunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN DATE;

TBD

EXECUTEDOUBLEFUNCTION

Undocumented dbms_clr.executedoublefunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN BINARY_DOUBLE;

TBD

EXECUTEFLOATFUNCTION

Undocumented dbms_clr.executeFloatfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN BINARY_FLOAT;

TBD

EXECUTEINTERVALDSFUNCTION

Undocumented dbms_clr.executeIntervalDSfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN INTERVAL DAY TO SECOND;

TBD

EXECUTEINTERVALYMFUNCTION

Undocumented dbms_clr.executeIntervalYMfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN INTERVAL YEAR TO MONTH;

TBD

EXECUTEINTFUNCTION

Undocumented dbms_clr.executeintfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

EXECUTELONGFUNCTION

Undocumented dbms_clr.executeLongfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN LONG;

TBD

EXECUTELONGRAWFUNCTION

Undocumented dbms_clr.executeLongRawfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN LONGRAW;

TBD

EXECUTENCHARFUNCTION

Undocumented dbms_clr.executeNCharfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN NCHAR;

TBD

EXECUTENCLOBFUNCTION

Undocumented dbms_clr.executeNClobfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN NCLOB;

TBD

EXECUTENUMBERFUNCTION

Undocumented dbms_clr.executeNumberfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN NUMBER;

TBD

EXECUTENVARCHARFUNCTION

Undocumented dbms_clr.dbms_clr.executeNVarcharfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN NVARCHAR;

TBD

EXECUTEPROCEDURE

Undocumented dbms_clr.executeprocedure( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2);

TBD

EXECUTERAWFUNCTION

Undocumented dbms_clr.executeRawfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN RAW;

TBD

EXECUTEROWIDFUNCTION

Undocumented dbms_clr.executeRowidfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN UROWID;

TBD

EXECUTETIMESTAMPFUNCTION

Undocumented dbms_clr.executeTimestampfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN TIMESTAMP;

TBD

EXECUTETIMESTAMPLTZFUNCTION

Undocumented dbms_clr.executeTimestampLTZfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN TIMESTAMP WITH LOCAL TIMEZONE;

TBD

EXECUTETIMESTAMPTZFUNCTION

Undocumented dbms_clr.executeTimestampTZfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN TIMESTAMP WITH TIMEZONE;

TBD

EXECUTEVARCHARFUNCTION

Undocumented dbms_clr.executeVarcharfunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN VARCHAR2;

TBD

EXECUTEXMLTYPEFUNCTION

Undocumented dbms_clr.executeXMLtypefunction( libraryname IN VARCHAR2, classname IN VARCHAR2, methodname IN VARCHAR2, securitylevel IN BINARY_INTEGER, dbmsclrinfo IN VARCHAR2) RETURN XMLType;

TBD

GETBFILEPARAMVALUE

Undocumented dbms_clr.getBFileParamValue(paramindex IN BINARY_INTEGER) RETURN BFile;

TBD

GETBLOBPARAMVALUE

Undocumented dbms_clr.getBlobParamValue(paramindex IN BINARY_INTEGER) RETURN BLOB;

TBD

GETCHARPARAMVALUE

Undocumented dbms_clr.getCharParamValue(paramindex IN BINARY_INTEGER) RETURN CHAR;

DECLARE

       retVal CHAR(10);

      BEGIN

        dbms_clr.setCharParam('ABC', 1, 1);

        retVal := dbms_clr.getCharParamValue(1);

        dbms_output.put_line(retVal);

      END;

      /

GETCLOBPARAMVALUE

Undocumented dbms_clr.getClobParamValue(paramindex IN BINARY_INTEGER) RETURN CLOB;

TBD

GETDATEPARAMVALUE

Undocumented dbms_clr.getDateParamValue(paramindex IN BINARY_INTEGER) RETURN DATE;

TBD

GETDBMSCLRVERSION

Returns the CLR version dbms_clr.getdbmsclrversion RETURN VARCHAR2;

SELECT dbms_clr.getDBMSCLRVersion

      FROM dual;

      

      GETDBMSCLRVERSION

      ------------------

      19.1.0.0.0

GETDOUBLEPARAMVALUE

Undocumented dbms_clr.getdoubleParamValue(paramindex IN BINARY_INTEGER) RETURN BINARY_DOUBLE;

TBD

GETFLOATPARAMVALUE

Undocumented dbms_clr.getFloatParamValue(paramindex IN BINARY_INTEGER) RETURN BINARY_FLOAT;

TBD

GETINTERVALDSPARAMVALUE

Undocumented dbms_clr.getIntervalDSParamValue(paramindex IN BINARY_INTEGER) RETURN INTERVAL DAY TO SECOND;

TBD

GETINTERVALYMPARAMVALUE

Undocumented dbms_clr.getIntervalYMParamValue(paramindex IN BINARY_INTEGER) RETURN INTERVAL YEAR TO MONTH;

TBD

GETINTPARAMVALUE

Undocumented dbms_clr.getIntParamValue(paramindex IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

GETLONGPARAMVALUE

Undocumented dbms_clr.getLongParamValue(paramindex IN BINARY_INTEGER) RETURN LONG;

TBD

GETLONGRAWPARAMVALUE

Undocumented dbms_clr.getLongRawParamValue(paramindex IN BINARY_INTEGER) RETURN LONG RAW;

TBD

GETNCHARPARAMVALUE

Undocumented dbms_clr.getNCharParamValue(paramindex IN BINARY_INTEGER) RETURN NCHAR;

TBD

GETNCLOBPARAMVALUE

Undocumented dbms_clr.getNClobParamValue(paramindex IN BINARY_INTEGER) RETURN NCLOB;

TBD

GETNUMBERPARAMVALUE

Undocumented dbms_clr.getNumberParamValue(paramindex IN BINARY_INTEGER) RETURN NUMBER;

TBD

GETNVARCHARPARAMVALUE

Undocumented dbms_clr.getNVarcharParamValue(paramindex IN BINARY_INTEGER) RETURN NVARCHAR;

TBD

GETRAWPARAMVALUE

Undocumented dbms_clr.getRawParamValue(paramindex IN BINARY_INTEGER) RETURN RAW;

TBD

GETROWIDPARAMVALUE

Undocumented dbms_clr.getRowidParamValue(paramindex IN BINARY_INTEGER) RETURN UROWID;

TBD

GETTIMESTAMPLTZPARAMVALUE

Undocumented dbms_clr.getTimestampLTZParamValue(paramindex IN BINARY_INTEGER) RETURN TIMESTAMP WITH LOCAL TIME ZONE;

TBD

GETTIMESTAMPPARAMVALUE

Undocumented dbms_clr.getTimestampParamValue(paramindex IN BINARY_INTEGER) RETURN TIMESTAMP;

TBD

GETTIMESTAMPTZPARAMVALUE

Undocumented dbms_clr.getTimestampTZParamValue(paramindex IN BINARY_INTEGER) RETURN TIMESTMAP WITH TIME ZONE;

TBD

GETVARCHARPARAMVALUE

Undocumented dbms_clr.getVARCHARParamValue(paramindex IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

GETXMLTYPEPARAMVALUE

Undocumented dbms_clr.getXMLTypeParamValue(paramindex IN BINARY_INTEGER) RETURN XMLTYPE;

TBD

SETBFILEPARAM

Undocumented dbms_clr.setBFileParam( paramvalue IN BFILE, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETBLOBPARAM

Undocumented dbms_clr.setBlobParam( paramvalue IN BLOB, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETCHARPARAM

Undocumented dbms_clr.setCharParam( paramvalue IN CHAR, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

See GETCHARPARAM Demo Above

SETCLOBPARAM

Undocumented dbms_clr.setClobParam( paramvalue IN CLOB, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETDATEPARAM

Undocumented dbms_clr.setDateParam( paramvalue IN DATE, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETDOUBLEPARAM

Undocumented dbms_clr.setdoubleParam( paramvalue IN BINARY_DOUBLE, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETFLOATPARAM

Undocumented dbms_clr.setFloatParam( paramvalue IN BINARY_FLOAT, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETINTERVALDSPARAM

Undocumented dbms_clr.setIntervalDSParam( paramvalue IN INTERVAL DAY TO SECOND, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETINTERVALYMPARAM

Undocumented dbms_clr.setIntervalYMParam( paramvalue IN INTERVAL YEAR TO MONTH, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETINTPARAM

Undocumented dbms_clr.setIntParam( paramvalue IN BINARY_INTEGER, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETLONGPARAM

Undocumented dbms_clr.setLongParam( paramvalue IN LONG, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETLONGRAWPARAM

Undocumented dbms_clr.setLongRawParam( paramvalue IN LONG RAW, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETNCHARPARAM

Undocumented dbms_clr.setNCharParam( paramvalue IN NCHAR, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETNCLOBPARAM

Undocumented dbms_clr.setNClobParam( paramvalue IN NCLOB, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETNUMBERPARAM

Undocumented dbms_clr.setNumberParam( paramvalue IN NUMBER, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETNVARCHARPARAM

Undocumented dbms_clr.setNVarcharParam( paramvalue IN NVARCHAR2, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETRAWPARAM

Undocumented dbms_clr.setRawParam( paramvalue IN RAW, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETROWIDPARAM

Undocumented dbms_clr.setRowidParam( paramvalue IN UROWID, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETTIMESTAMPLTZPARAM

Undocumented dbms_clr.setTimestampLTZParam( paramvalue IN TIMESTAMP WITH LOCAL TIME ZONE, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETTIMESTAMPPARAM

Undocumented dbms_clr.setTimestampParam( paramvalue IN TIMESTAMP, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETTIMESTAMPTZPARAM

Undocumented dbms_clr.setTimestampTZParam( paramvalue IN TIMESTAMP WITH TIME ZONE, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETVARCHARPARAM

Undocumented dbms_clr.setVarcharParam( paramvalue IN VARCHAR2, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD

SETXMLTYPEPARAM

Undocumented dbms_clr.setXMLtypeParam( paramvalue IN XMLTYPE, paramdirection IN BINARY_INTEGER, typemapping IN BINARY_INTEGER);

TBD