Question
AMEX
US
Last activity: 26 Jul 2017 1:34 EDT
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..
Accepted Solution
AMEX
US
Hi Kevin,
I figured out the problem..
It was an access issue. The user configured for my Pega Server was different.
I am able to access the Procedure..
Thank you..
Pegasystems Inc.
US
Pegasystems Inc.
US
can you capture the actual sql (use tracer or db trace) to see if your SP is schema qualified? If not, try to specify the schema name before the SP name (e.g., <schema>.find_cpp(...).
AMEX
US
I tried both the ways.. I created simple stored procedures but even they are not working.
Somehow Pega is not picking on the procedures. I am able to run the procedure from sqldeveloper with the same user and schema..
Accepted Solution
AMEX
US
Hi Kevin,
I figured out the problem..
It was an access issue. The user configured for my Pega Server was different.
I am able to access the Procedure..
Thank you..
IN
I use this syntax in 7.1.8.
Call Data.ProcName(
{TempData.TASKASSIGNEDTO in},{TempData.StartsFrom in} ,{TempData.EndsOn in},{TempData.Status1 in},{TempData.Status2 in},{TempData.Status3 in},{.MaxAddPayUnprcsdID out},{.Message out},{resultset}
)