Oracle DBMS_CLR
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Undocumented: Previously appeared in 11gR2, not found in 12.1.0.1, but found again in 12.1.0.2 and missing again in 12.2.0.1.
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
Subprograms
 
CLEARPARAMETERS
Undocumented dbms_clr.clearParameters;
exec dbms_clr.clearParameters;
 
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(
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
 
EXECUTEDFLOATFUNCTION
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.executeNVarcharFunction(
libraryname   IN VARCHAR2,
classname     IN VARCHAR2,
methodname    IN VARCHAR2,
securitylevel IN BINARY_INTEGER,
dbmsclrinfo   IN VARCHAR2)
RETURN NVARCHAR;
TBD
 
EXECUTEDPROCEDURE
Undocumented dbms_clr.executeProcedureFunction(
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;
BEGIN
  retVal := dbms_clr.getCharParamValue(1);
  dbms_output.put_line(retVal);
END;
/
DECLARE
*
ERROR at line 1:
ORA-06533: Subscript beyond count
ORA-06512: at "SYS.DBMS_CLR", line 741
ORA-06512: at line 4
 
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
Undocumented dbms_clr.getDBMSCLRVersion RETURN VARCHAR2;
SELECT dbms_clr.getDBMSCLRVersion
FROM dual;
 
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);
TBD
 
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
 
SETBDOUBLEPARAM
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
Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved