Question

3
Replies
237
Views
SudhanshuY Member since 2013 14 posts
Labb Consulting
Posted: 3 years ago
Last activity: 3 years 4 months ago
Closed

Issue in Calling DB function Using RDB-Open after upgrading from 6.2 SP2 to Pega 7.2.2

Hello,

We have upgrade our application from Pega 6.2 SP2 to Pega 7.2.2 and in our application using RDB-Open we are running below query:

select GETPVIID() as "tempPVIID" from DUAL where rownum = 1

where GETPVIID() is a DB function but after upgrade this script started throwing below error:

java.sql.SQLSyntaxErrorException: ORA-00904: "GETPVIID": invalid identifier

I am attaching also the complete log file. Please let us know why above query is giving error.

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