目前的问题是不知道如何返回游标,以下是我写得包 CREATE OR REPLACE package testpack is type C_BRS is ref cursor; procedure BackResultSet(myC_BRS out C_BRS); end; / CREATE OR REPLACE package BODY testpack as procedure BackResultSet(myC_BRS out C_BRS) is begin open myC_BRS for select * from REGTABLE where name = 'bjs'; end BackResultSet; end testpack; / 包是写出来了,但是如何在JSP里调用呢? 我用的方法是: <% String procedure = "{call testpack.BackResultSet(?)}"; CallableStatement cstmt = conn.prepareCall(procedure); cstmt.registerOutParameter(1,Types.OTHER); cstmt.execute(); %> 只是对存储过程调用,这种方法call testpack.BackResultSet(?)总是报错呀,是不是JSP里调用包的方法不一样呀 请高手指点一二,谢谢了。
CREATE OR REPLACE package testpack
is
type C_BRS is ref cursor;
procedure BackResultSet(myC_BRS out C_BRS);
end;
/
CREATE OR REPLACE package BODY testpack
as
procedure BackResultSet(myC_BRS out C_BRS)
is
begin
open myC_BRS for select * from REGTABLE where name = 'bjs';
end BackResultSet;
end testpack;
/
包是写出来了,但是如何在JSP里调用呢?
我用的方法是:
<%
String procedure = "{call testpack.BackResultSet(?)}";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.registerOutParameter(1,Types.OTHER);
cstmt.execute();
%>
只是对存储过程调用,这种方法call testpack.BackResultSet(?)总是报错呀,是不是JSP里调用包的方法不一样呀
请高手指点一二,谢谢了。