Question

2
Replies
184
Views
DILIP MONDAL (DilipKMondal)
Cognizant Technology Solutions

Cognizant Technology Solutions
CA
DilipKMondal Member since 2012 14 posts
Cognizant Technology Solutions
Posted: January 9, 2016
Last activity: January 15, 2016
Posted: 9 Jan 2016 16:43 EST
Last activity: 15 Jan 2016 13:22 EST
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

Show More

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

Show Less
Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.