Question

2
Replies
836
Views
Close popover
Naga venkata Naveen (NagavenkataN7265)
American Express

American Express
IN
NagavenkataN7265 Member since 2016 3 posts
American Express
Posted: January 30, 2017
Last activity: February 6, 2017
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 System Administration Upgrades
Moderation Team has archived post