Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'REPORT_SQL

User_RIDJGJan 30 2019 — edited Jan 31 2019

Hi whenever i'm trying to monitor SQL using EM 13c Cloud , I'm getting the following error: java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'REPORT_SQL_MONITOR_LIST'

I've searching web and get some solution to apply patch, but when I try to monitor the SQL on oracle DB version: 12.1 I'm getting the output result without error.

OMSPatcher Version: 13.8.0.0.0

OPlan Version: 12.1.0.2.2

Any body pls help me to resolve the issue. error.PNG

working.PNG

Dear, Any solution except applying Patch?

OEM Version: 13.2.0.0

DB Version: 12c , SQL Monitoring Working from OEM 13c

DB Version: 11g , SQL Monitoring Not Working from OEM 13c

Comments

Post Details

Added on Jan 30 2019
#general-database-discussions
1 comment
597 views