CREATE OR REPLACE PROCEDURE DeleteFolder(delId IN INT, IDS OUT INT) AS
BEGIN
select count(*) into IDS from DOCTREE where PARENTID=delId;
IF IDS==0 THEN
delete from DOCTREE d where d.ID=delId;
END IF
END DeleteFolder;
在oracle sql developer中编译
提示:
“Warning: 执行完毕, 但带有警告”
oracle的存储过程不是太熟
望指教!
BEGIN
select count(*) into IDS from DOCTREE where PARENTID=delId;
IF IDS==0 THEN
delete from DOCTREE d where d.ID=delId;
END IF
END DeleteFolder;
在oracle sql developer中编译
提示:
“Warning: 执行完毕, 但带有警告”
oracle的存储过程不是太熟
望指教!