我写的存储过程，单独执行没有问题，但是在asp中一调用就出问题。
出错信息如下，
ADODB.Recordset 错误 '800a0e78'
Operation is not allowed when the object is closed
请问这是什么原因？？
存储过程如下：
create proc SL_USA_DISPLAY
(@SVC_LOOP CHAR(4) ,
@VESSEL CHAR(3) ,
@VOYAGE CHAR(3) ,
@DIRECTION CHAR(1) ,
@POL CHAR(3) ,
@POD CHAR(3) ,
@STATUS CHAR(20)
)
as
declare @COUNT_O int,
@COUNT_N int,
@COUNT_S int
create table #temp_result
( BL_NO char(12)
,SVVD char(14)
,UPDATE_DATE datetime
,STATUS char(20)
,POD char(3)
,TYPE char(20)
,TOTAL_ORIGINAL int
,TOTAL_SEND int
,TOTAL_NOSEND int
)
select @COUNT_O=0
select @COUNT_N=0
select @COUNT_S=0
create table #temp02
( BL_NO char(12)
,SVVD char(14)
,UPDATE_DATE datetime
,STATUS char(20)
,POD char(3)
,TYPE char(20)
)
if @STATUS='IB'
begin
insert into #temp02
select BL_NO,(SVC_LOOP+'/'+VESSEL+'/'+VOYAGE+'/'+DIRECTION)as SVVD,UPDATE_DATE,STATUS,POD,
TYPE=(case when TYPE='E' then 'EDI3.1'
when TYPE='I' then 'IRIS2'
else 'no such type' end)
from BL_MAIN
where
SVC_LOOP= @SVC_LOOP AND VESSEL= @VESSEL AND
VOYAGE= @VOYAGE AND DIRECTION= @DIRECTION AND
POL_LAST= @POL AND POD_FIRST =@POD AND
(STATUS='SENDING' OR STATUS='ORIGINAL' or
STATUS='NO SENDING') AND CONV_STATUS='COMPLETED' AND
BL_NO NOT IN ( select MASTER_BL from HB_MB_CONV) order by status
select @COUNT_O=count() from #temp02 where STATUS='ORIGINAL'
select @COUNT_S=count() from #temp02 where STATUS='SENDING'
select @COUNT_N=count(*) from #temp02 where STATUS='NO SENDING'
insert into #temp_result
select B.BL_NO,
B.SVVD,
B.UPDATE_DATE,
B.STATUS,
B.POD,
B.TYPE,
@COUNT_O,
@COUNT_S,
@COUNT_N
from #temp02 B
end
select * from #temp_result
恳请高手帮忙，高分相送！
---------------------------------------------------------------
asp代码的问题。
---------------------------------------------------------------
不是存储过程的问题，根据错误提示有可能是asp代码中的错误
检查一下是否在执行了connection, recordset的close命令后仍在继续使用该对象
---------------------------------------------------------------
把ＡＳＰ代码贴出来看看
---------------------------------------------------------------
检查一下是否在执行了connection, recordset的close命令后仍在继续使用该对象
---------------------------------------------------------------
你可能提前关闭了对象