Question
Evoke Technologies
IN
Last activity: 10 May 2024 3:46 EDT
Oracle Stored Procedures ResultSets
Hi All,
We are using a Stored Procedure to override a certain value of an External Database. Whenever the stored procedure is performed, the external Table will provide response by ResultSets. Our requirement is to capture the response through resultsets via Connect-SQL. We have tried to capture the response by providing the below Query statement in the Browse tab.
\{ {resultset} = CALL StoredProcedure({TempPage.Key1 IN},{TempPage.Key1 IN},{TempPage.Key2 IN},{TempPage.Key3 IN},{TempPage.Key4 IN},{TempPage.Key5 IN},{TempPage.Key6 IN},{TempPage.Key7 IN},{resultset},{resultset} ) \}
but upon tracing, we are getting the following error in the MySQLErrorPage
| pxRDBSQLVendorMessage1 | Invalid JDBC data type -10. |
| pxRDBError | There was a problem performing a database query: There was a problem getting a list: code: 0 SQLState: <none> Message: Invalid JDBC data type -10. DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid JDBC data type -10. | SQL Code: 0 | SQL State: null |
| pzStatus | valid |
Let us know what could possibly be wrong to cause this error.
Hi All,
We are using a Stored Procedure to override a certain value of an External Database. Whenever the stored procedure is performed, the external Table will provide response by ResultSets. Our requirement is to capture the response through resultsets via Connect-SQL. We have tried to capture the response by providing the below Query statement in the Browse tab.
\{ {resultset} = CALL StoredProcedure({TempPage.Key1 IN},{TempPage.Key1 IN},{TempPage.Key2 IN},{TempPage.Key3 IN},{TempPage.Key4 IN},{TempPage.Key5 IN},{TempPage.Key6 IN},{TempPage.Key7 IN},{resultset},{resultset} ) \}
but upon tracing, we are getting the following error in the MySQLErrorPage
| pxRDBSQLVendorMessage1 | Invalid JDBC data type -10. |
| pxRDBError | There was a problem performing a database query: There was a problem getting a list: code: 0 SQLState: <none> Message: Invalid JDBC data type -10. DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid JDBC data type -10. | SQL Code: 0 | SQL State: null |
| pzStatus | valid |
Let us know what could possibly be wrong to cause this error.
We have developed the above syntax with reference from this article: https://docs-previous.pega.com/how-process-result-set-returned-oracle-stored-procedures
Note: There was a error in the configuring the syntax and what's why we were facing this error. This is resolved.
Thanks,
Abhiveer Jatla.