oif sqlrowcount1then s_state_values:0end ifexception when others then s_state_values:1commitend /create or replace procedure p_delete_stup_stu_no in student.stu_notypes_state_values out numberasbegindelete from gd where gd_stu_nop_stu_nodelete from student where stu_nop_stu_nos_state_values:0exception when others then s_state_values:1rollbackcommitend/create or replace procedure p_update_gdp_gd_stu_no in gd.gd_stu_notypep_gd_sub_subject in gd.gd_sub_subjecttypep_gd_grade in gd.gd_gradetypes_state_values out numberasbeginupdate gdset gd_stu_nop_gd_stu_nogd_sub_subjectp_gd_sub_subjectgd_gradep_gd_gradewhere gd_stu_nop_gd_stu_no and gd_sub_subjectp_gd_sub_subjectif sqlrowcount1then s_state_values:0end ifexception when others then s_state_values:1rollbackcommitend /create or replace procedure p_delete_gdp_gd_stu_no in gd.gd_stu_notypep_gd_sub_subject in gd.gd_sub_subjecttypes_state_values out numberasbegindelete from gdwhere gd_stu_nop_gd_stu_no and gd_sub_subjectp_gd_sub_subjectif sqlrowcount1then s_state_values:0end ifexceptio.
上一篇:
计算器论文(修改好的)
下一篇:
你有多稳,就能做多大的事