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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
RAC
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx