Question
American Express
IN
Last activity: 6 Feb 2017 5:45 EST
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
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
Accepted Solution
Pegasystems Inc.
IN
Hi,
Nagavenkata has found the solution to the question. He shared this information via an email to the moderator.
Here is the resolution step- "Put schema name before stored procedure name in your code. It will resolve the error."
~Vidyaranjan A V | Community Moderator | PegaProductSupport | Pegasystems Inc.
Pegasystems Inc.
IN
Hello NagaVenkata,
Check if the stored procedure have the matching datatypes sequentially or not and also the number of arguments are matching .
Thanks,
Arun
Accepted Solution
Pegasystems Inc.
IN
Hi,
Nagavenkata has found the solution to the question. He shared this information via an email to the moderator.
Here is the resolution step- "Put schema name before stored procedure name in your code. It will resolve the error."
~Vidyaranjan A V | Community Moderator | PegaProductSupport | Pegasystems Inc.