Oracle ODCIVARCHAR2LIST
Version 26ai

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is offering technical seminars focused on protecting Oracle Databases from Agentic AI attack.

To arrange a workshops for your organization send an email to damorgan@uw.edu and request a complimentary seminar for your organization today.
DDL CREATE OR REPLACE TYPE ODCIVarchar2List FORCE
OID '0000000000000000000000000002121C' AS VARRAY(32767) OF VARCHAR2(4000);
/
Dependencies
CTX_DDL RDF_APIS SEM_RDFCTX_IR
CTX_QUERY RDF_APIS_INTERNAL SEM_RDFSA_DR
DBMS_GVT RDF_MATCH_IMPL_T S_SDO_RDF_INFO
DBMS_ISCHED SDO_RDF S_SDO_RDF_INTERNAL
DBMS_SCHEDULER SDO_RDF_INTERNAL S_SDO_RDF_QUERY
DBMS_SQLHIST SDO_RDF_JAVA_STP S_SEM_RDFCTX_DR
DBMS_SQLHIST_INTERNAL SDO_RDF_REL2RDF_INTERNAL S_SEM_RDFSA_DR
DRVDML SDO_SEM_INF_INTERNAL W_SDO_RDF_ALL
DRVLSB SEM_OLS W_SEM_RDFCTX_ALL
DRVPARX SEM_RDFCTX_DR W_SEM_RDFSA_ALL
PRLLIDX_CREATE    
Documented No
First Available Not Known
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/catodci.sql
 
Demo
Type Usage Demo conn uwclass/uwclass@pdbdev

col program_id format a11

SELECT DISTINCT program_id
FROM airplanes
INTERSECT
SELECT *
FROM TABLE(sys.OdciVarchar2List('717', '727', '737', '747'));

Related Topics
Built-in Functions
Built-in Packages
Database Security
OdciArgDescList
OdciBFileList
OdciColInfoList
OdciDateList
OdciNumberList
OdciObjectList
OdciPatInfoList
OdciRawList
OdciRidList
DBMS_ODCI
ODCICONST
What's New In 21c
What's New In 26ai

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