- 3,708,902 Users
- 2,241,153 Discussions
- 7,840,697 Comments
Forum Stats
Discussions
Categories
- 99 Community Feedback - NEW! (No Product Questions)
- 43 General Community Platform Concerns/Kudos/Feedback
- 37 Community Platform Bug Reports
- 55 How Do I? (Community Platform "How to" Questions)
- 11 Where is the...? (Community Platform Locations)
- 9 I'd Like to See... (Community Platform Ideas & Suggestions)
- 11.2K Community Feedback (No Product Questions) Archive
- 64 Personal Document & Blog Archive
- 2 Community Programs
- 2 Get-Togethers
- 56 Certification Community
- 4.7K Certification Community Discussions
- 31 Oracle Certified Master Profiles
- 25 Oracle Database 12c Administrator Certified Master Profiles
- 28 Visual Builder Cloud Service
Accessing SQL Monitoring Raises ORA-06553: PLS-306: wrong number or types of arguments in call to 'R
Venkata Thiruveedhi-Oracle
Posts: 590 Employee
When navigating to the SQL Monitoring page, the error below is raised:
java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'REPORT_SQL_MONITOR_LIST'
Steps to reproduce the issue:
EM13c --> Click on a database target --> Performance --> SQL Monitoring page
The issue occurs on 11g (or lower) database targets using OEM 13.2 or 13.1 with the EM DB Plugin Bundle Patch 13.1.1.0.161018 applied.
Issue is due to the following bug:
Bug 21503575 - SLOW SQL ACTIVITY PERFORMANCE PAGE (TOP ACTIVITY)
Issue is fixed in the bug below, which is scheduled to be included in a future EM Plugin bundle patch.
Bug 24914115 - ORA-06553: PLS-306: wrong number or types of arguments in call to 'REPORT_SQL_MO
Reference:
Doc ID 2199723.1 : EM13c: Accessing SQL Monitoring Raises ORA-06553: PLS-306: wrong number or types of arguments in call to 'REPORT_SQL_MONITOR_LIST'
The document will be updated accordingly once announced the exact bundle patch number/release where the bug fix will be included.