利用dblink调用存储过程出现错误
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'JXJK.P_INF_ICT_CREATECUST@ICT_TO_CRM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
如果是去掉用户前缀JXJK.就可以了(对方分配的用户)
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'JXJK.P_INF_ICT_CREATECUST@ICT_TO_CRM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
如果是去掉用户前缀JXJK.就可以了(对方分配的用户)
create or replace procedure abc
as
begin
scott.sca@eos('a');
end;java调用
oracle.jdbc.OracleCallableStatement cst2 = (oracle.jdbc.OracleCallableStatement)conn.prepareCall("call scott.sca@eos('a')");均没有问题。请LZ说说你详细的调用情况。