Discussion List

• substring CLOB value with value more than 32K

  1 view 1 comment 0 points Most recent by Mohammad Shaddad May 10, 2021 9:47AMPL/SQL (MOSC)
• I want to use Integrated SOA Gateway to update Payment Acknowledgment

  Question 1 view 0 comments 0 points Most recent by akshaykumar644 May 1, 2021 8:16PMInstall, Upgrade, Clone, Patch - EBS (MOSC)
• Issue with CLOB - Value or Numeric Error

  Question 1 view 0 comments 0 points Most recent by Darsh_ Apr 23, 2021 8:03PMPL/SQL (MOSC)
• PLS-00302: component 'R' must be declared

  Question 11 views 0 comments 0 points Most recent by MLA Prakash Apr 22, 2021 4:37AMProcurement - EBS (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)
• Greater than Zero values not retruned in PLSQL function

  11 views 4 comments 0 points Most recent by MLA Prakash Apr 1, 2021 10:11AMSQL Language (MOSC)
• getting error while fetching multiple records in plsql

  21 views 4 comments 0 points Most recent by Mark D Powell Mar 29, 2021 6:47PMPL/SQL (MOSC)
• Not able to update tables using Anonymous block in PLSQL

  Answered 1 view 2 comments 0 points Most recent by AB115 Mar 19, 2021 1:31PMPL/SQL (MOSC)
• Compilation warning on create type

  11 views 8 comments 0 points Most recent by User_2VU7B Feb 22, 2021 1:50PMSQL Language (MOSC)
• How to Set/Pass 'Operating Unit' for a child request of a Request Set.

  Answered 51 views 1 comment 0 points Most recent by Mark D Powell Feb 3, 2021 5:38PMPL/SQL (MOSC)
• PLS-05018

  Answered ✓ 11 views 6 comments 0 points Most recent by Suzanne_London Jan 20, 2021 3:09PMPL/SQL (MOSC)
• PL/SQL commands affected from upgrading 11g to 19c

  Answered 11 views 2 comments 0 points Most recent by Victor Vic Dec 28, 2020 2:10AMInstall, Upgrade, Clone, Patch - EBS (MOSC)
• Does number of columns on a table affect performance ?

  Answered ✓ 21 views 14 comments 0 points Most recent by User_OWR9X Dec 3, 2020 2:12AMSQL Performance (MOSC)
• Data that differ between tables

  Answered 1 view 1 comment 0 points Most recent by Mark D Powell Dec 1, 2020 9:17PMPL/SQL (MOSC)
• Oracle DBMS_DEBUG.GET_VALUE can't get variable values when debugging large packages

  Answered 1 view 1 comment 0 points Most recent by Mark D Powell Oct 16, 2020 3:16PMPL/SQL (MOSC)
• What is the difference between CURRENT_IS_ROLE_ENABLED and SESSION_IS_ROLE_ENABLED

  Answered 21 views 2 comments 0 points Most recent by Gaz in Oz Oct 13, 2020 12:57AMSQL Language (MOSC)
• Fetching All Data from Sys_refcursor

  Answered 141 views 16 comments 0 points Most recent by Billy Verreynne Jul 24, 2020 2:19PMPL/SQL (MOSC)
• Schedule a program every 2 weeks

  Answered 81 views 4 comments 0 points Most recent by Gaz in Oz Jun 20, 2020 11:35PMPL/SQL (MOSC)
• Security model for access to PL/SQL packages

  Answered 97 views 4 comments 0 points Most recent by Mark D Powell Jun 1, 2020 10:45AMPL/SQL (MOSC)
• Security Model for PL/SQL packages

  Answered 80 views 2 comments 0 points Most recent by SherrieK May 29, 2020 1:37PMPL/SQL (MOSC)
• Getting Subscript beyond count while calling procedure which accepts input as record type

  Answered 104 views 1 comment 2 points Most recent by GregV May 26, 2020 2:27AMPL/SQL (MOSC)
• LOOP - Iteration based on Profile Value

  Answered 104 views 6 comments 1 point Most recent by User_FHYJ0 May 7, 2020 10:55AMPL/SQL (MOSC)
• Using APEX_LDAP.IS_MEMBER With Active Directory

  Answered 124 views 6 comments 0 points Most recent by DHaanpaa-TAX Mar 25, 2020 12:11PMPL/SQL (MOSC)
• How to call stored procedures with non-scalar arguments - replicating old ALL_ARGUMENTS views

  Answered 116 views 1 comment 2 points Most recent by GregV Feb 14, 2020 3:33AMPL/SQL (MOSC)
• Advisor Webcast Questions? EBS Logistics - PL/SQL APIs as REST Webservices - Webcast Held On Septemb

  Answered 48 views 1 comment 0 points Most recent by Vishnu-Oracle Aug 15, 2019 10:19AMInventory Management - EBS (MOSC)
• Restoring Dropped Objects

  Answered 42 views 1 comment 0 points Most recent by Radu-Oracle Jul 16, 2019 5:03AMUsing the My Oracle Support Portal (MOSC)
• ORA-01427: single-row subquery returns more than one row

  Answered 51 views 2 comments 0 points Most recent by cormaco Jun 28, 2019 5:13AMBI Publisher (MOSC)
• Single-quotes not working in SQL statement run from scheduled SQL*Plus script or PL/SQL script.

  Answered 47 views 11 comments 0 points Most recent by Mark D Powell Mar 12, 2019 12:28PMDatabase Administration (MOSC)
• HTTPS call from plsql package not getting reponse after 30 minutes

  Question 68 views 0 comments 0 points Most recent by MVelling Dec 11, 2018 11:07AMEBS Customizations (MOSC)
• DBMS_OBFUSCATION_TOOLKIT.DESdecrypt function returns with some invisible values

  Answered ✓ 76 views 1 comment 0 points Most recent by MVelling Jul 18, 2018 2:58PMEBS Customizations (MOSC)