tag:blogger.com,1999:blog-9023262881452307990.post5817096606240722964..comments2016-02-22T09:11:15.562-08:00Comments on Dinusha's Blog: How to use UDT (User Difined Types) within WSO2 Data Services Server ?Dinushahttp://www.blogger.com/profile/08040437234230433433noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-9023262881452307990.post-3087875212535558202015-09-07T10:13:12.726-07:002015-09-07T10:13:12.726-07:00Hi Dinusha. It´s possible with WSO2 DSS call a pro...Hi Dinusha. It´s possible with WSO2 DSS call a procedure that return an UDT array? Please checkout this question: <br /><br />http://stackoverflow.com/questions/32443270/call-a-procedure-or-funcion-in-oracle-db-with-return-array-of-udt-from-wso2-ds<br /><br />Thanks,<br /> Jorge.Jorgehttps://www.blogger.com/profile/09341790011949595757noreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-42816355024337264852013-04-26T03:38:20.100-07:002013-04-26T03:38:20.100-07:00Looks like the , code was not accepted.You can ref...Looks like the , code was not accepted.You can refer to the "http://stackoverflow.com/questions/15108432/wso2-dataservice-facing-unable-to-retrieve-udt-value-error-when-executin" for the code.Sireeshahttps://www.blogger.com/profile/00134864231480365177noreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-82073865645180848072013-04-26T03:36:17.663-07:002013-04-26T03:36:17.663-07:00Hi Dinusha
I am trying call Stored procedure that ...Hi Dinusha<br />I am trying call Stored procedure that has UDT , using WSO2DSS.<br /> Version : MAC OS X - 10.7.5 with WSO2 ESB 4.0.3 having installed feature of Data Service feature - 3.2.3<br /><br />"<br /> <br /> DataSource<br /> <br /> <br /> {call PRO_ALERT_DISP_FLOAT(:IN_DS_ID,:IN_PRIORITY,:IN_TIME_OFFSET,:IO_STATUS,:out_display_list,:IO_IS_ADMIN_GENERIC)}<br /> <br /> 60000<br /> forward<br /> 1000<br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /> <br /><br />"<br />All I get is <br />"[2013-04-26 15:53:52,183] ERROR - SQLQuery Conversion to String failed<br />java.sql.SQLException: Conversion to String failed<br /> at oracle.sql.Datum.stringValue(Datum.java:181)<br /> at oracle.jdbc.driver.ArrayDataResultSet.getString(ArrayDataResultSet.java:155)<br /> at org.wso2.carbon.dataservices.core.engine.ResultSetWrapper.getString(ResultSetWrapper.java:58)<br /> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.getDataEntryFromRS(SQLQuery.java:1143)<br /> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.getAllDataEntriesFromRS(SQLQuery.java:960)<br /> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processStoredProcQuery(SQLQuery.java:920)<br /> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:2044)<br /> at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:252)<br /> at org.wso2.carbon.dataservices.core.engine.CallQuery.execute(CallQuery.java:185)<br /> at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.execute(CallQueryGroup.java:110)<br /> at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:71)<br /> at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:592)<br /> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:99)<br />"<br /><br />Could you please let me know as what could be the issue. I did make sure that the xsdType match that of the procedure output.?Sireeshahttps://www.blogger.com/profile/00134864231480365177noreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-20576109059289742562013-04-03T05:52:33.411-07:002013-04-03T05:52:33.411-07:00Hi Dinusha,
I have one Query
Here i am sending th...Hi Dinusha,<br /><br />I have one Query<br />Here i am sending the my GIT URL which contain my Query<br /><br />https://gist.github.com/anonymous/5300686<br /><br />Could you please help me.<br />Thanks in Advance<br />Anil<br /><br />Hi Lakmali,<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9023262881452307990.post-36894119203546394592012-02-13T01:15:04.540-08:002012-02-13T01:15:04.540-08:00Hi dinusha , thanks for your blog, it's very h...Hi dinusha , thanks for your blog, it's very helpful for me ! I have question about the UDT.. I was wondering if the UDT works if there are defined at level package like :<br /><br />create or replace<br />PACKAGE PCKTYPE AS <br /><br /> type numerostel is table of number(1) index by binary_integer;<br /><br />END PCKTYPE;<br /><br />I've tried to use my UDT as you explain in the post but it's not working .. I've sql error:<br /> java.sql.SQLException: invalid name pattern: : MY_SCHEMA.PCKTYPE.NUMEROSTELAnonymoushttps://www.blogger.com/profile/09226005358574566677noreply@blogger.com