Question

2
Replies
747
Views
NagavenkataN7265 Member since 2016 3 posts
American Express
Posted: 3 years ago
Last activity: 3 years 7 months ago
Closed
Solved

There was a problem getting a list: code: 6576 SQLState: 65000 Message: ORA-06576: not a valid function or procedure name

Hi All,

During run time, I am getting the below error from an activity, was doing RDB-open where I am calling a stored procedure.

Here is my code in open tab of conect-SQL

call SPPC_XXXXXXX (
{pgUniqueID.ReturnKey OUT},
{pgUniqueID.tpyPrefix },
{pgUniqueID.tpyOrganization },
{pgUniqueID.tsuffix }
)

There was a problem getting a list: code: 6576 SQLState: 65000 Message: ORA-06576: not a valid function or procedure name

and connect-SQL rule keys, one of the key is DB2 but i am currently using Oracle 11g so is there any problem with this key.

and mine is a Upgrade project from Pega 6.1 with DB2 to Pega 7.2 Oracle. Kindly advice me.

Thanks,

Naveen

Data Integration Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn