存储过程:
CREATE OR REPLACE PROCEDURE "WL"."TEST" (
pRecCur out TestPackage.TestResultSet
)
is
begin
open pRecCur for select comno from commodity;
end;
这个存储过程已经侧过 可以我的调用java代码:public class ConDBExample {
public static void main(String[] args){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection c=DriverManager.getConnection("jdbc:oracle:thin:@172.16.21.223:1521:ora64","wl","123");
CallableStatement stmt = c.prepareCall("{?=call test() }");
stmt.registerOutParameter(1, Types.VARCHAR);
stmt.executeQuery();
}
catch(Exception e){
System.out.println(e);
}
}
}
运行报错显示:
java.sql.SQLException: ORA-06550: 第 1 行, 第 13 列:
PLS-00306: 调用 'TEST' 时参数个数或类型错误
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored怎么解决啊
CREATE OR REPLACE PROCEDURE "WL"."TEST" (
pRecCur out TestPackage.TestResultSet
)
is
begin
open pRecCur for select comno from commodity;
end;
这个存储过程已经侧过 可以我的调用java代码:public class ConDBExample {
public static void main(String[] args){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection c=DriverManager.getConnection("jdbc:oracle:thin:@172.16.21.223:1521:ora64","wl","123");
CallableStatement stmt = c.prepareCall("{?=call test() }");
stmt.registerOutParameter(1, Types.VARCHAR);
stmt.executeQuery();
}
catch(Exception e){
System.out.println(e);
}
}
}
运行报错显示:
java.sql.SQLException: ORA-06550: 第 1 行, 第 13 列:
PLS-00306: 调用 'TEST' 时参数个数或类型错误
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored怎么解决啊
试试看