---------------------------------------------------------------------------- ************-- 作者 : 周黎-- 创建日期 : 2009-08-18 9:13-- 描述 :所有存储过程开头-- D_删除操作-- U_更新操作-- I_插入操作--------------------------------------------------------------------------- ---------------------- 主函数--------------------CREATE OR REPLACE PACKAGE China IS
--1.删除行业分类A及子分类的存储过程 操作表:corp_classa PROCEDURE D_ClassA(ClassNum in number); --2.删除行业分类B及子分类的存储过程 操作表:corp_classb PROCEDURE D_ClassB(ClassNum in number);end China;---------------------- 函数体--------------------CREATE OR REPLACE PACKAGE BODY China IS --1.删除行业分类A及子分类的存储过程 操作表:corp_classa PROCEDURE D_ClassA(ClassNum in number) AS BEGIN DELETE FROM corp_classa WHERE class_number=ClassNum; DELETE FROM corp_classb WHERE classa_number=ClassNum; DELETE FROM corp_classc WHERE classa_number=ClassNum; END D_ClassA; --2.删除行业分类B及子分类的存储过程 操作表:corp_classb PROCEDURE D_ClassB(ClassNum in number) AS BEGIN DELETE FROM corp_classb WHERE class_number=ClassNum; DELETE FROM corp_classc WHERE classb_number=ClassNum; END D_ClassB;END China;
-------------------------------------------以上为SQL语句 要注意的是主函数 和函数体要分开执行,否则报错----------------------------------
-------------------------------------------下为代码调用模块----------------------------------
OracleParameter[] parameters = { new OracleParameter("ClassNum", OracleType.Number) };parameters[0].Value = ID;DbHelperSQL.ExecuteSql("China.D_ClassB", CommandType.StoredProcedure, parameters);