Forum Stats

  • 3,708,902 Users
  • 2,241,153 Discussions
  • 7,840,697 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Accessing SQL Monitoring Raises ORA-06553: PLS-306: wrong number or types of arguments in call to 'R

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.

Sign In or Register to comment.