Question

2
Replies
179
Views
DilipKMondal Member since 2012 14 posts
Cognizant Technology Solutions
Posted: January 9, 2016
Last activity: January 15, 2016
Closed
Solved

How Pega will work with Oracle sys.OdciVarchar2List(Extensibility Types - System Defined Constants and System Defined Types)

ODCIVarchar2List

Stores varrays of VARCHAR2s

Datatype

VARRAY(32767) OF VARCHAR2(4000)

For Stored Procedures with OUT Parameter of these Types, which property types are suitable for this?

   SP (
         INKEY1 IN VARCHAR2,
         ARESULT1 OUT SYS.ODCIVARCHAR2LIST
        
        )

Reference: Extensibility Types - System Defined Constants and System Defined Types

+-------------+--------------+----------------------+------+-----------+ |COLL_TYPE |ELEM_TYPE_NAME|TYPE_NAME |LENGTH|UPPER_BOUND| +-------------+--------------+----------------------+------+-----------+ |TABLE |NUMBER |KU$_OBJNUMSET |{null}| {null}| |TABLE |NUMBER |KU$_XMLCOLSET_T |{null}| {null}| |TABLE |NUMBER |ORA_MINING_NUMBER_NT |{null}| {null}| |TABLE |VARCHAR2 |DBMS_AW$_COLUMNLIST_T | 100| {null}| |TABLE |VARCHAR2 |DBMS_DEBUG_VC2COLL | 1000| {null}| |TABLE |VARCHAR2 |HSBLKNAMLST | 30| {null}| |TABLE |VARCHAR2 |KU$_VCNT | 4000| {null}| |TABLE |VARCHAR2 |ORA_MINING_VARCHAR2_NT| 4000| {null}| |VARYING ARRAY|NUMBER |AWRRPT_NUM_ARY |{null}| 30| |VARYING ARRAY|NUMBER |JDM_NUM_VALS |{null}| 999| |VARYING ARRAY|NUMBER |ODCIGRANULELIST |{null}| 65535| |VARYING ARRAY|NUMBER |ODCINUMBERLIST |{null}| 32767| |VARYING ARRAY|NUMBER |SQL_OBJECTS |{null}| 2000| |VARYING ARRAY|NUMBER |TABLESPACE_LIST |{null}| 64000| |VARYING ARRAY|VARCHAR2 |AQ$_JMS_NAMEARRAY | 200| 1024| |VARYING ARRAY|VARCHAR2 |AQ$_MIDARRAY | 32| 1024| |VARYING ARRAY|VARCHAR2 |AWRRPT_VCH_ARY | 80| 30| |VARYING ARRAY|VARCHAR2 |DBMSOUTPUT_LINESARRAY | 32767| 2147483647| |VARYING ARRAY|VARCHAR2 |DBMS_XS_ROLELIST | 1024| 4096| |VARYING ARRAY|VARCHAR2 |FLASHBACKTBLIST | 30| 100| |VARYING ARRAY|VARCHAR2 |HSBLKVALARY | 4000| 250| |VARYING ARRAY|VARCHAR2 |JDM_ATTR_NAMES | 60| 999| |VARYING ARRAY|VARCHAR2 |JDM_STR_VALS | 4000| 999| |VARYING ARRAY|VARCHAR2 |KU$_DROPCOLLIST | 4000| 1000| |VARYING ARRAY|VARCHAR2 |KUPC$_LOBPIECES | 4000| 4000| |VARYING ARRAY|VARCHAR2 |ODCIRIDLIST | 5072| 32767| |VARYING ARRAY|VARCHAR2 |ODCIVARCHAR2LIST | 4000| 32767| |VARYING ARRAY|VARCHAR2 |RE$NAME_ARRAY | 30| 1024| |VARYING ARRAY|VARCHAR2 |RE$RULE_LIST | 65| 1024| |VARYING ARRAY|VARCHAR2 |SQLPROF_ATTR | 500| 2000| |VARYING ARRAY|VARCHAR2 |TXNAME_ARRAY | 256| 100| +-------------+--------------+----------------------+------+-----------+
Data Integration
Moderation Team has archived post
Share this page LinkedIn