Using Custom type in toracleSP, basically how to get Struct descriptor and Struct posted to Oracle Procedure

[Anonymous]

Kindly wanted to know how to pass Oracle defined type in tOracleSP.

Use Case:

===============

CREATE OR REPLACE PACKAGE DB SCHEMA.PACKA_DATA AS


TYPE T1 IS RECORD
   (COLUMN1                       TABLE1.COL1%TYPE,
    COLUMN2                       TABLE1.COL2%TYPE,
    COLUMN3                       TABLE1.COL3%TYPE,
   );
   
--***************************************************************************************

PROCEDURE DOTBJ (p_Operation  IN      VARCHAR2,
                 p_TbjRec     IN OUT  PACKA_DATA.T1) IS
                
                 BEGIN

 
   --- Operation to Insert the record

END DOTBJ;

Requirement how can I insert record with Talend toracleSP Component

[Anonymous]

Hello,

Now it supports collections of objects for custom types.

Have you tried to call the Stored Procedure with Parameter Type : IN, DBType : AutoMapping, Click Custom Type, Custom Type as Array?

Here is a use case in this jira issue:https://jira.talendforge.org/browse/TDI-22045.

Best regards

Sabrina