Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in 19.2 Report Link

Larry RDec 9 2019 — edited Dec 17 2019

We recently migrated our APEX 4.2.3 application up to our new APEX 19.2 environment.  On one page of the application, there were many classic reports that were converted to interactive reports when the application was imported.  All of the reports have column links to other pages that have to be re-created after migration.  Upon running the page to display the reports with the re-created link, the "ORA-28817: PL/SQL function returned an error." message is captured in the debug.  The SQL for the report itself runs without error in SQL Developer on the same database.  Is there a setting that needs to be changed in order to display interactive reports with column links in 19.2?

Comments
Post Details
Added on Dec 9 2019
4 comments
296 views