RDB-List not get results

General
,
1

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!

2

Hi @WalkerW16594292,

Can you elaborate on what the exact issue or error you are getting?

If possible provide screenshots.

Thanks,

Lakshman.

3

@WalkerW16594292 Are you using correct syntax to execute the SP ?

4

@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.

5

@MarijeSchillern Thanks for the suggestion! But it has been implemented in other ways, thank you!