Oracle Stored procedure which will return a value back to PEGA
I am attempting to call a stored procedure from Oracle which will return a value back to PEGA. I continue to get various errors on the tracer. Is there a tutorial or some solid information with “clear” examples…
I have already reviewed to following:
https://pdn.pega.com/how-process-result-set-returned-oracle-stored-procedures
Does a function within PEGA need to be create first…
If so where and how.
Just to confirm, does a PEGA function (not stored procedure) needed to be created first....
Also, the second link does not open.
I'm not entirely sure what you mean by Pega function. I don't believe a Rule-Utility-Function would be needed though, if this is what you meant.
For that second link, I'm not too sure what happened as I can see the colon in the text, but hovering over the link the tooltip doesn't show it. So you may just want to re-add it into your browser, after clicking on the link.
In step 1, this link says wrap Oracle stored procedure in a function: https://pdn.pega.com/calling-stored-procedure-returns-resultset-oracle/…
In step 1, this link creates a stored function: https://pdn.pega.com/how-process-result-set-returned-oracle-stored-proc…
The resolution in this link for step 1, creates the SQL Function: https://pdn.pega.com/support-articles/error-while-calling-sql-function-…
Hi Sandeep,
I don't think that you need any explicit function to just call a store proc. You can consider below example to call store proc which sends and receives data from store proc. You can call store from Browse tab of Connect SQL rule.
\{ call purge_log_table ({purgePg.purgeDays }, {purgePg.status OUT}) \}
I hope this will help.
Would this syntax be different if it is an Oracle store procedure....
Yes this is Oracle Store proc syntax.
In step 1, this link says wrap Oracle stored procedure in a function: https://pdn.pega.com/calling-stored-procedure-returns-resultset-oracle/…
In step 1, this link creates a stored function: https://pdn.pega.com/how-process-result-set-returned-oracle-stored-proc…
The resolution in this link for step 1, creates the SQL Function: https://pdn.pega.com/support-articles/error-while-calling-sql-function-…
Hi,
Please refer to below links on how to call a stored procedure using Connect-SQL
https://pdn.pega.com/community/product-support/question/it-possible-cal…
https://pdn.pega.com/node/8755/book_pdf
https://pdn.pega.com/support-articles/error-while-calling-sql-function-…
In case if you are still facing issues, please share the error you are getting in tracer.