
How to pass collections to PL/SQL package from OIC
Sep 4, 2024 · Summary: We are in the process of transferring all direct table operations (insert/update/delete) from the OIC database activity to a PL/SQL package.
Oracle Fusion ERP Analytics
What is the cause of this error: ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 797 ?
Steps to resolve "PL/SQL package SYS.DBMS_RCVMAN version …
Feb 11, 2025 · That all worked great but the alert log has these messages PL/SQL package SYS.DBMS_BACKUP_RESTORE version is not current PL/SQL package …
Error in main at step 15: ORA-06502: PL/SQL: numeric or value error
May 6, 2024 · Getting this error "Error in main at step 15: ORA-06502: PL/SQL: numeric or value error" when running the Demantra Configuration Analyzer in EBS R12.2.10 on Oracle 19c …
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 …
Apr 25, 2022 · PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current PL/SQL
getting ORA-06511: PL/SQL: cursor already open — oracle-mosc
Sep 7, 2015 · 06511. 00000 - "PL/SQL: cursor already open" *Cause: An attempt was made to open a cursor that was already open. *Action: Close cursor first before reopening. …
How to convert LONG to VARCHAR2 in PL/SQL — oracle-mosc
Feb 21, 2023 · I want to convert LONG to VARCHAR2 in PL/SQL on the fly. Note that we are using AL32UTF8 characterset. Below works only when view text is smaller than 8K.
How to burst BI Publisher reports that use PL/SQL Procedure call ...
Feb 24, 2025 · I've used the following PL/SQL code:How to burst BI Publisher reports that use PL/SQL Procedure call?
Is it possible to run a PL/SQL statement in an Oracle Alert action?
Dec 13, 2012 · EBS Customizations (MOSC) Is it possible to run a PL/SQL statement in an Oracle Alert action? Dec 13, 2012 1:06AM edited Aug 11, 2015 10:01AM 9 comments Answered
RMAN: PL/SQL package SYS.DBMS_BACKUP_RESTORE version is …
Dec 8, 2020 · We just upgraded our database from version 11.2.0.4. We are seeing the following errors in the alert log and when connecting to rman: PL/SQL package …