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

Anonymous — Tue, 02 Oct 2018 20:41:56 GMT

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

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

Anonymous — Tue, 16 Oct 2018 10:03:21 GMT

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

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

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

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