Question
HKEX
CN
Last activity: 4 Jun 2024 22:12 EDT
RDB-List not get results
Hi Team,
I created an SP and wanted to get the results through the RDB-List
But I found that my stored procedure can be executed successfully and get results when executed in the database, But when I use RDB-List it doesn't return a result.
For example:
In DB, exec procedurename '20240423'
In RDB-List, \{Call procedurename('20240423') \}
Due to the complex business logic, I used a temporary table in SP. I am not sure whether it is because of this I cannot get the result through RDB-List... Has anyone ever been in a similar situation?
Thank you!
Accepted Solution
Updated: 4 Jun 2024 22:12 EDT
Pegasystems Inc.
GB
@WalkerW16594292 Based on the information provided, there could be several reasons why your stored procedure is not returning results when called via RDB-List in Pega. It could be due to syntax issues in SQL Connect rules, access issues, or issues related to driver types for PegaRules and External databases. However, without more specific information, it's hard to provide a definitive answer.
https://docs.pega.com/bundle/platform/page/platform/reference/methods/rdb-list.html
instasmart software solutions
IN
Hi @WalkerW16594292,
Can you elaborate on what the exact issue or error you are getting?
If possible provide screenshots.
Thanks,
Lakshman.
Tata Consultancy Services
GB
@WalkerW16594292Are you using correct syntax to execute the SP ?
Accepted Solution
Updated: 4 Jun 2024 22:12 EDT
Pegasystems Inc.
GB
@WalkerW16594292 Based on the information provided, there could be several reasons why your stored procedure is not returning results when called via RDB-List in Pega. It could be due to syntax issues in SQL Connect rules, access issues, or issues related to driver types for PegaRules and External databases. However, without more specific information, it's hard to provide a definitive answer.
https://docs.pega.com/bundle/platform/page/platform/reference/methods/rdb-list.html
HKEX
CN
@MarijeSchillern Thanks for the suggestion! But it has been implemented in other ways, thank you!