问题遇到的现象和发生背景
我要在Java代码中调用 p_proc_info 这个存储过程 ,它是PROCEDURE而不是function
问题相关代码,请勿粘贴截图
dbCstmt = dbConn.prepareCall("{call p_proc_info(?,?,?)}");
dbCstmt.setString(1, pMsg);
dbCstmt.registerOutParameter(2, Types.INTEGER);
dbCstmt.registerOutParameter(3, Types.VARCHAR);
运行结果及报错内容
org.postgresql.util.PSQLException: ERROR: function p_proc_info(character varying) does not exist
建议:No function matches the given name and argument types. You might need to add explicit type casts.