这里写自定义目录标题
ORACLE 迁移POLARDB-O之存储调用
存储过程中使用入参为INOUT时问题
问题,调用存储过程报
com.aliyun.polardb.util.PSQLException: ERROR: cannot assign to a constant parameter
at com.aliyun.polardb.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2729)
at com.aliyun.polardb.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2341)
at com.aliyun.polardb.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:340)
at com.aliyun.polardb.jdbc.PgStatement.executeInternal(PgStatement.java:486)
at com.aliyun.polardb.jdbc.PgStatement.execute(PgStatement.java:403)
## 这里写一个测试存储过程
** CREATE OR REPLACE PROCEDURE mcsmaster.eccsv53(
INOUT p_msgid character varying,
p_procid character varying,
OUT p_f64out character varying)
LANGUAGE ‘edbspl’
SECURITY DEFINER VOLATILE PARALLEL UNSAFE
COST 100
AS
B
O
D
Y
BODY
BODY
BEGIN
select ‘8’ into p_f64out ;
DBMS_OUTPUT.PUT_LINE(p_f64out);
select ‘2’ into p_msgid ;
END
B
O
D
Y
BODY
BODY;
ALTER PROCEDURE mcsmaster.eccsv53(character varying, character varying)
OWNER TO mcsmaster;
**
## 测试脚本调用
`这里类似咱们JAVA中的 值传递和引用传递,想到这里如果存储之间相互调用可以先声明一个变量来作为入参,但是JAVA中使用JDBC如何操作`
## 修改后JAVA jdbc 写法