Oracle DBMS_CLR
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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