Enterprise Manager Generic (MOSC)

MOSC Banner

Failed to get test Metric Extension metric result.: no out-bind bound

edited Feb 9, 2016 9:27AM in Enterprise Manager Generic (MOSC) 1 commentAnswered

Hi,

I am using PL/SQL in metric extension and getting error:

Failed to get test Metric Extension metric result.: no out-bind bound

Below is plsql:

declare gap integer;

begin

IF not dbms_utility.is_cluster_database THEN

     select sum(local.sequence#-target.sequence#) Total_gap into gap

    from (select thread#,max(sequence#) sequence# from gv$archived_log

where standby_dest='YES'  and applied='YES'

and first_time between sysdate-7 and sysdate

group by thread#) target,

(select thread#,max(sequence#) sequence# from gv$log group by thread#) local

where target.thread#=local.thread#;

end if;

end ;

I have defined out parameter position 1 and out parameter type as SQL_CURSOR

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center