Question

1
Replies
53
Views
Debasmita Sarkar (DEBASMITA)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN
DEBASMITA Member since 2014 2 posts
Cognizant Technology Solutions
Posted: November 23, 2020
Last activity: November 23, 2020
Posted: 23 Nov 2020 8:10 EST
Last activity: 23 Nov 2020 8:17 EST
Solved

Returning Resultset from Oracle to Pega

Hi,

 

I'm trying to return a resultset from Oracle DB in Pega. For this, as per below link,

  https://pdn.pega.com/calling-stored-procedure-returns-resultset-oracle/calling-stored-procedure-returns-resultset-oracle

 

I've created a table structure and returning the results in table format.

I'm able to get the result in Oracle using the below query:

SELECT * FROM TABLE(schemaname.func_name'userid')) where user id is the input parameter.

But when I'm putting it in COnnect-SQL, under Browse tab, I'm getting the error message:

There was a problem performing a database query: There was a problem getting a list: code: 933 SQLState: 42000 Message: ORA-00933: SQL command not properly ended DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

 

Please help.

 

Thanks and Regards,

Debasmita

 

Pega Platform 7.3.1 Project Delivery Healthcare and Life Sciences