Question

7
Replies
6031
Views
Close popover
VENKATA SUMANTH KRISHNA NORI (VENKATASUMANTHKRN7364)
AMEX

AMEX
US
VENKATASUMANTHKRN7364 Member since 2015 9 posts
AMEX
Posted: March 30, 2016
Last activity: July 26, 2017
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.