Support Article
Unable to set output of database function
SA-42783
Summary
When configuring a Connect SQL rule to execute an Oracle database which returns a number, cannot be set to a Pega property.
Error Messages
Not Applicable
Steps to Reproduce
- Invoke a RDB-List step in an activity to reference a Connect SQL rule that calls a database function.
- Write the result of this function to a property.
Root Cause
A defect or configuration issue in the operating environment:
Syntax to set the value was incorrect.
result := NBAMEXTERNALO.get_offer_count('BATCHOUTCMPR20','VarFieldsTest');
{TestPage:pyCount} := result;
Resolution
Perform the following local-change:
Set the return value as below to resolve the issue:
\{{TestPage.pyCount out} = call NBAMEXTERNALO.get_offer_count ({TestPage.ACCT_NME},{TestPage.DEV_COLOR_NME})\}
Published December 5, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.