Question

7
Replies
5908
Views
VENKATASUMANTHKRN7364 Member since 2015 9 posts
AMEX
Posted: 4 years ago
Last activity: 3 years 2 months ago
Closed
Solved

Pega 7.1.8 Calling Stored Procedure

Hi Team,

I am calling a stored procedure (oracle) which accepts 1 input and returns 1 output.

I am using a Connect-SQL (browse) tab to call the stored procedure.

When I run the activity which calls RDB-List, it is returning the below error:

<pxRDBError>There was a problem performing a database query: There was a problem getting a list: code: 6550 SQLState: 65000 Message: ORA-06550: line 1, column 7: PLS-00201: identifier 'FIND_CCP' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored</pxRDBError><pxSQLStatementPre>\{ call find_ccp({mySQLPage.EmployeeID IN},{mySQLPage.pyUserIdentifier OUT})\}

I tried using RDB-Open. still the same issue.

Please help..

Pega Customer Service Data Integration Low-Code App Development System Administration
Moderation Team has archived post
Share this page LinkedIn