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://docs.pega.com/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 |