delete from 不能执行
CREATE OR REPLACE PROCEDURE UPDATEALLSTOP
(
cityname IN NVARCHAR2
)
AS
BEGIN
delete from PT_STOP where PTS_CITY=cityname;
FOR REC IN ( SELECT * FROM PT_LINE where PTL_CITY=cityname )
LOOP
inputstop(cityname, rec.PTL_NAME, rec.PTL_GOSTOPLIST, rec.PTL_RTNSTOPLIST);
END LOOP;
COMMIT;
END;
上面过程,每次执行到delete from PT_STOP where PTS_CITY=cityname;时就过不去,为什么?
不是权限的问题,用SYS用户也不行。