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
v_date DATE;
BEGIN
SELECT TO_DATE (d, 'yyyy-mm-dd')
INTO v_date
FROM DUAL;
RETURN v_date;
EXCEPTION
WHEN OTHERS
RETURN NULL;
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;