- Dennis Huynh
- PowerBuilder
- Friday, 18 October 2019 09:43 PM UTC
Hi,
Please help ... DBA informed the following error. We just recently upgraded Oracle to 12c. The owner for PowerBuilder Catalog tables was not SYSTEM and some how the SQL was generated with SYSTEM.
WARNING: too many parse errors, count=100 SQL hash=0x384a3478
PARSE ERROR: ospid=6063, error=942 for statement:
SELECT PBD_FHGT,PBD_FWGT,PBD_FITL,PBD_FUNL,PBD_FCHR,PBD_FPTC,PBD_FFCE,PBH_FHGT,PBH_FWGT,PBH_FITL,PBH_FUNL,PBH_FCHR,PBH_FPTC,PBH_FFCE,PBL_FHGT,PBL_FWGT,PBL_FITL,PBL_FUNL,PBL_FCHR,PBL_FPTC,PBL_FFCE,PBT_CMNT FROM SYSTEM.PBCATTBL WHERE PBT_OWNR = :1 AND PBT_TNAM = :2
Warm regards and Thanks,
Dennis
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.