BPM, Workflow, and Case

 View Only

 Is it possible to using custom type in sqlParam ?

  • IBMChampion
Ziyad Hamed's profile image
Ziyad Hamed posted Wed January 08, 2025 03:36 AM

Hello all,

If I make a custom data type on my oracle database for example:
CREATE TYPE StringList IS TABLE OF VARCHAR2(4000); 
Is it possible to send this type from BPM using sqlParam? for example if I will call stored procedures with one INPUT Argument which its type is StringList , I already made on database

ـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ
tw.local.pSql = 'CALL SHCEMA.SP_EXAMPLE(?)';
 
tw.local.sqlParam[0] = new tw.object.SQLParameter();
tw.local.sqlParam[0].value = "["string1","string2","string3"]";
tw.local.sqlParam[0].type = "StringList";
tw.local.sqlParam[0].mode = "IN";
ـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ
I catch this error 
Unkown param type 
I want to know If there's a way to send my custom type via sqlParam
Also, what is the valid types to send
Atanu Roy's profile image
Atanu Roy IBM Champion posted Wed January 08, 2025 11:22 PM

Hi Ziyad,

I don't think it is possible, it should be supported by the JDBC driver as well.

Thanks!

Related Content