Discussion List

• Invalid WMSYS objects in DBA_OBJECTS

  Answered 133 views 5 comments 0 points Most recent by User_MCJ2F Feb 1, 2022 7:14PMPL/SQL (MOSC)
• Returning multiple values from a PL/SQL FUNCTION.

  Answered ✓ 11 views 3 comments 0 points Most recent by GregV Jan 26, 2022 8:52PMPL/SQL (MOSC)
• global temp table can be used as Organization external TYPE oracle_loader table?

  Question 1 view 0 comments 0 points Most recent by User_M3HXT Dec 20, 2021 6:26PMEBS Customizations (MOSC)
• reply-to not working in XML Bursting. 12.2.9

  Answered ✓ 1 view 3 comments 0 points Most recent by DGray Dec 17, 2021 6:53PMEBS Customizations (MOSC)
• ACL creation, directory location, and confusion.

  Answered ✓ 51 views 8 comments 0 points Most recent by User_HKP4W Dec 2, 2021 5:29PMDatabase Install/Upgrade/Opatch (MOSC)
• Recommendation for SAST (static security analysis) tool for Oracle PL/SQL code

  Answered 121 views 2 comments 0 points Most recent by JohnWatson2 Oct 15, 2021 5:34PMDatabase Administration (MOSC)
• Oracle Store procedure running long time compared to Sql plus

  Answered ✓ 1 view 5 comments 0 points Most recent by SureshMuddaveerappa Sep 30, 2021 3:50AMPL/SQL (MOSC)
• I keep getting SQL query execution plan contains merge cartesian joins..

  Answered 1 view 7 comments 0 points Most recent by SureshMuddaveerappa Sep 3, 2021 10:53PMPL/SQL (MOSC)
• OeBS AR module, question to file attached to a customer invoice

  Question 1 view 0 comments 0 points Most recent by User_3S9CJ Aug 20, 2021 1:51PMPL/SQL (MOSC)
• Want to call Installment update REST API from PL/SQL

  Question 1 view 0 comments 0 points Most recent by User_D8DS8 Aug 12, 2021 12:31PMPL/SQL (MOSC)
• Query Widememo/CLOG/LONG field in FF_formulas_f

  Answered ✓ 61 views 9 comments 0 points Most recent by DGray Jul 7, 2021 8:37PMHuman Capital Management - EBS (MOSC)
• want to trap any exception when insert in table fails.

  11 views 3 comments 0 points Most recent by GregV Jun 15, 2021 11:21AMSQL*Plus (MOSC)
• EXECUTE IMMEDIATE returns wrong record-count.

  Answered 31 views 7 comments 0 points Most recent by Mark D Powell May 11, 2021 4:04PMPL/SQL (MOSC)
• How do i fix this error: PLS-00302: component 'JOBNO' must be declared

  Answered 1 view 2 comments 0 points Most recent by Anyika Ugochukwu Raphael Apr 16, 2021 3:37PMPL/SQL (MOSC)
• How to create dynamic folder on the server using plsql package and zip that folder

  Answered 11 views 1 comment 0 points Most recent by GregV Apr 9, 2021 8:46AMPL/SQL (MOSC)
• How to update/insert the table if cursor returns 0 records?

  Answered 11 views 3 comments 0 points Most recent by DGray Apr 6, 2021 3:41PMPL/SQL (MOSC)
• ORA-600 Error

  11 views 3 comments 0 points Most recent by Arsalan Dehghanisariyarghan Feb 24, 2021 1:46PMDatabase ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)
• pn_streams_util.put_log What does this mean?

  Answered ✓ 1 view 1 comment 0 points Most recent by Monika G-Oracle Feb 24, 2021 1:57AMProperty Manager - EBS (MOSC)
• Need help with run in PL/SQL but NOT in SQL+

  Answered 11 views 4 comments 0 points Most recent by Mark D Powell Feb 23, 2021 6:26PMPL/SQL (MOSC)
• Debug package problem

  Answered 11 views 10 comments 0 points Most recent by SureshMuddaveerappa Feb 14, 2021 7:29PMPL/SQL (MOSC)
• weirdness with UTL_FILE.FOPEN

  21 views 2 comments 0 points Most recent by Mark D Powell Feb 9, 2021 4:44PMPL/SQL (MOSC)
• fractional seconds in to_utc_timestamp_tz?

  Answered ✓ 31 views 2 comments 0 points Most recent by User_IVLGF Feb 2, 2021 2:32PMPL/SQL (MOSC)
• Recompile invalid object with utlrp.sql

  91 views 6 comments 0 points Most recent by Mark D Powell Feb 1, 2021 1:26PMDatabase Administration (MOSC)
• Transpose Options in SQL

  Answered 1 view 1 comment 0 points Most recent by Mark D Powell Jan 29, 2021 7:56PMSQL Language (MOSC)
• Does creating view consume tablespace ?

  Answered ✓ 21 views 9 comments 0 points Most recent by Mark D Powell Jan 28, 2021 7:28PMDatabase Administration (MOSC)
• How to duplicate pages in Oracle APEX 4.2 without overwriting the in-session value of the items?

  Question 1 view 0 comments 0 points Most recent by User_532TL Jan 28, 2021 4:54PMPL/SQL (MOSC)
• NO Error but also no result

  Answered ✓ 11 views 3 comments 0 points Most recent by SureshMuddaveerappa Jan 25, 2021 12:03AMPL/SQL (MOSC)
• Dividing dump file using plsql datapump api

  Answered ✓ 1 view 2 comments 0 points Most recent by User_IKZ7V Jan 11, 2021 10:09AMPL/SQL (MOSC)
• Truncate Partition

  Answered 11 views 3 comments 0 points Most recent by SureshMuddaveerappa Jan 10, 2021 4:28AMPL/SQL (MOSC)
• SAP HANA PROBLEM PERFORMANCE NVARCHAR

  Answered 21 views 4 comments 0 points Most recent by Mark D Powell Dec 14, 2020 4:06PMSQL Performance (MOSC)