Error(29,13): PL/SQL: ORA-04063: table "SVISTA.INST_CURR_CNVT_RATE" has errors

Hello ,

I have 2 DB:

1. ACLLOG --> Single , normal database

2. dgsvfe      -> RAC Standby database

They locate in different server

We want ACLLOG select data from standby daabase dgsvfe:

On ACLLOG we create db link name SVFE link to database dgsvfe

then Create Precedure on ACLLOG for collect data from dgsvfe as below:

create or replace PROCEDURE SV_ABL_EXCH_RATE_LAO

(

  P_DATE_FROM NVARCHAR2,

  P_DATE_TO NVARCHAR2,

  OUTPUT OUT SYS_REFCURSOR

)

/*

  variable a refcursor;

   exec SV_ABL_EXCH_RATE_LAO('20161206','20161212',:a);

  print a;

*/

IS

  V_DATE_FR DATE;

  V_DATE_TO DATE;

BEGIN

V_DATE_FR := to_date(P_DATE_FROM,'yyyymmdd');