调存储过程不能带SCHEMA???
JDBC:
String sql = "{call \"myschema\".my_proc(?, ?, ?)}";
String sql = "{call myschema.my_proc(?, ?, ?)}";
SQLPLUS:
execute "myschema".my_proc(101570,:c1,:c2);
即使登录用户也是myschema, 都出错:
ORA-06550: line 1, column 16:
PLS-00302: component 'my_proc' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
去掉SCHEMA就可以,但如果my_proc在其他SCHEMA,就不行了:
String sql = "{call my_proc(?, ?, ?)}";
难道 调存储过程不能带SCHEMA???