Use round function to rounding to 2 decimal places
Nov 21, 2024 · Summary: Use round function to rounding to 2 decimal places Content (please ensure you mask any confidential information): Hi experts, I working in data maping but I need …
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 …
How to define pl/sql triggers in oracle hcm
Jun 10, 2024 · Summary: I want a list of pl/sql functions from HCM that can be added as triggers.
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 …
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. …
find which PL/SQL Procedure is running in a session (using call …
Aug 10, 2009 · Hi, I would like to know how you can see which proc is currently running in an active session. DBMS_UTILITY.FORMAT_CALL_STACK let you view the stack for the current …
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.
Is it possible to set SQL/JSON queries to return clob as default
Sep 30, 2020 · Hi, I'm using Oracle DB 19c (19.0.0.0.0) SQL/JSON queries in PL/SQL: json_arrayagg, json_object etc. with large quantity of nested data and need to set the …
Getting ORA-06502: PL/SQL: numeric or value error: character to …
Mar 19, 2024 · Summary: Hi I m using below query as subquery for a report but it is giving numeric or value error:
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