我已经成功将游标记录显示到ASP页面上了。但现在如何将另一个输出值(getcount)显示到页面中??帮忙修改下面这段ASP代码。
set cmdcount=server.createobject("ADODB.COMMAND"
cmdcount.ActiveConnection=conn
cmdcount.CommandType=4
cmdcount.prepared=true
cmdcount.CommandText="{call zsl_pack_message.getcount()}"
cmdcount.Parameters.Append cmdcount.CreateParameter("v_count",2,2)
set recordcount=v_count
set recordcount=cmdcount.execute
CREATE OR REPLACE PACKAGE zsl_pack_message
AS
TYPE mytype IS REF CURSOR;
PROCEDURE getcursor (r_cursor OUT mytype);
PROCEDURE getcount(v_count OUT integer);
END zsl_pack_message;
/
CREATE OR REPLACE PACKAGE BODY zsl_pack_message
AS
PROCEDURE getcursor (r_cursor OUT mytype)
is
BEGIN
OPEN r_cursor FOR select * from ZSL_VW_ZSL_MESSAGE;
END;
PROCEDURE getcount(v_count OUT integer)
is
BEGIN
select count(*)into v_count from ZSL_VW_ZSL_MESSAGE;
END;