Create Procedure DELETE_SPXX @SP_ID int
as
begin
DELETE FROM SPPDB WHERE SP_ID=@SP_ID
DELETE FROM THCLITEMKCDD WHERE SP_ID=@SP_ID
DELETE FROM SPKCSLZ WHERE SP_ID=@SP_ID
DELETE FROM SPSYJL WHERE SP_ID=@SP_ID
DELETE FROM THCLITEM WHERE SP_ID=@SP_ID
DELETE FROM SPFPCJC WHERE SP_ID=@SP_ID
DELETE FROM SPSYJL WHERE SP_ID=@SP_ID
DELETE FROM JHDITEM WHERE SP_ID=@SP_ID
DELETE FROM PHDITEMFPC WHERE SP_ID=@SP_ID
DELETE FROM PHDITEM WHERE SP_ID=@SP_ID
DELETE FROM SPSLZR WHERE SP_ID=@SP_ID
DELETE FROM THCLITEMKCDD WHERE SP_ID=@SP_ID
DELETE FROM SPKCSLZ WHERE SP_ID=@SP_ID
DELETE FROM SPPDB WHERE SP_ID=@SP_ID
DELETE FROM SPSYJL WHERE SP_ID=@SP_ID
DELETE FROM GTSP WHERE SP_ID=@SP_ID
DELETE FROM SPBARCODE WHERE SP_ID=@SP_ID
DELETE FROM SPKCSLZ WHERE SP_ID=@SP_ID
DELETE FROM BJJL WHERE SP_ID=@SP_ID
DELETE FROM JJBJDITEM WHERE JLBH IN (SELECT JLBH FROM JJBJD WHERE SP_ID=@SP_ID)
DELETE FROM JJBJD WHERE SP_ID=@SP_ID
DELETE FROM SPKCZT WHERE SP_ID=@SP_ID
DELETE FROM XSBMTZDITEM WHERE SP_ID=@SP_ID
DELETE FROM JSDITEM WHERE SP_ID=@SP_ID
DELETE FROM SPXX WHERE SP_ID=@SP_ID
END
这是地一个存储过程。
这是第二个存储过程。
create Procedure DELETESPXX
AS
BEGIN
declare @SP_ID_del int
declare @BARCODE CHAR(13)

declare curSPXX cursor for
select A.SP_ID,A.BARCODE
from SPXX A,GTSP B
where A.SP_ID=B.SP_ID
AND B.DEPTID='020304'
AND A.SP_ID<>7499
for read only

open curSPXX
fetch curSPXX into @SP_ID_del,@BARCODE
while (@@sqlstatus = 0)
begin
PRINT '开始del' print '' print ''
PRINT @BARCODE
execute DELETE_SPXX @SP_ID_del
PRINT '结束del' print '' print '' print ''

fetch curSPXX into @SP_ID_del,@BARCODE
end
close curSPXX
deallocate Cursor curSPXX

END
在第二个存储过程调用第一个的时候，提示如下：
Msg 582, Level 16, State 3
Cursor 'curSPXX' was closed implicitly because the current cursor position was deleted due to an update or a delete. The cursor scan position could not be recovered. This happens for cursors which reference more than one table.
Msg 559, Level 16, State 1
Attempt to use a cursor 'curSPXX' which is not open. Use the system stored procedure sp_cursorinfo for more information.
怎么解决？
谢谢