ANBOB™

when you try to access a table over the database link,mybe get this error

CREATE OR REPLACE FUNCTION ICME.todate (d VARCHAR2)
   RETURN DATE
IS
   v_date   DATE;
BEGIN
   SELECT TO_DATE (d, 'yyyy-mm-dd')
     INTO v_date
     FROM DUAL;

   RETURN v_date;
EXCEPTION
   WHEN OTHERS
   THEN
      RETURN NULL;
END;
/


update  ncme_study_credit@ncme set icme_mark=todate('1949-10-1')  where CREDIT_TYPE ='X2' AND USER_NAME='liqiao198458'

ORA-02069: global_names parameter must be set to TRUE for this operation

解决方法：
1，update ncme_study_credit@ncme set icme_mark=to_date(‘1949-10-1′,’yyyy-mm-dd’) where CREDIT_TYPE =’X2′ AND USER_NAME=’liqiao198458′
2, 把函数在远程数据库中
3,alter session/system set global_names=true
4,远程数据库创建一个和当前select * from global_name查询结果一样的同名database_link;

打赏

微信扫一扫，打赏作者吧～