Hi Alpesh, DSS does not currently support UDTs to be passed into a data service as input parameters. However, if your UDT carries a very primitive sort of a structure without any nested UDTs inside, you should be able to pass them in in-line as shown below. Refer the following DSS query configuration, in which "address_t" is a UDT that has primitive data types defined in its structure.
... <query id="q2" useConfig="default"> <sql>INSERT INTO customer_tbl VALUES(?, ?, *address_t(?,?,?,?,?)*)</sql> <param name="ID" sqlType="INTEGER" /> <param name="Name" sqlType="STRING" /> <param name="Number" sqlType="INTEGER" /> <param name="Street" sqlType="STRING" /> <param name="City" sqlType="STRING" /> <param name="State" sqlType="STRING" structType="null" /> <param name="Country" sqlType="STRING" /> </query> ... The definition of "address_t" is given below. CREATE OR REPLACE TYPE address_t AS OBJECT(num NUMBER, street VARCHAR2(100), city VARCHAR2(100), STATE VARCHAR2(100), country VARCHAR2(100)); / I understand that the proposed workaround is not too "enterprisy", as in reality, most of the enterprises would typically deal with quite complex UDTs with nested UDTs, etc. However, what's described above is what can be done with DSS ATM. HTH! Cheers, Prabath On Fri, Apr 22, 2016 at 7:37 PM, Alpesh <[email protected]> wrote: > Hi Prabath, > > I am trying to use UDT as input in Oracle Procedure. > Do you have any documentation on how to map UDT as input to DSS? > > Thanks and Regards, > Alpesh > > > > -- > View this message in context: > http://wso2-oxygen-tank.10903.n7.nabble.com/Implementing-UDT-User-Defined-Types-support-for-Data-Services-tp67537p135298.html > Sent from the WSO2 Architecture mailing list archive at Nabble.com. > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > -- Prabath Abeysekara Technical Lead WSO2 Inc. Email: [email protected] Mobile: +94774171471
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
