createorreplaceproceduretest_cjsql(in_sqlnrinclob,in_bzhjsjkdmsinvarchar2,in_d" />

ڵλ:С˵ > п

oracle系列教材 (一

ʱ䣺2019-08-23 11:19༭վԭĶ128

    oracle系列教材 (一

    双击选中所有代?/h5>">createorreplaceproceduretest_cjsql(in_sqlnrinclob,in_bzhjsjkdmsinvarchar2,in_dxlxdminvarchar2,out_codeinoutvarchar2,out_messinoutvarchar2)AuthidCurrent_UserIS/*sql*/PRAGMAAUTONOMOUS_TRANSACTION;/**/c_sqlnrclob;V_SQLERRVARCHAR2(255);jb_errEXCEPTION;BEGIN--c_sqlnr:=replace(in_sqlnr,chr(10),chr(32));/**/--c_sqlnr:=replace(c_sqlnr,chr(13),chr(32));/**/--c_sqlnr:=trim(trailingfromc_sqlnr);/**/c_sqlnr:=trim(trailingfromin_sqlnr);/**/BEGIN/*ddl12*//*mysqloracle*//*ifin_dxlxdm03orin_dxlxdm=03and(in_bzhjsjkdmsisnullorinstr(in_bzhjsjkdms,SJBSHX001)0orinstr(in_bzhjsjkdms,YYZC001)0orinstr(in_bzhjsjkdms,YYZC002)0)thenifinstr(c_sqlnr,mysql)0then--mysql只记录不执行null;elseEXECUTEIMMEDIATEc_sqlnr;--endif;endif;*//*oracle*/ifin_dxlxdm03orin_dxlxdm=03and(in_bzhjsjkdmsisnullorinstr(in_bzhjsjkdms,SJBSHX001)0orinstr(in_bzhjsjkdms,YYZC001)0orinstr(in_bzhjsjkdms,YYZC002)0)thenEXECUTEIMMEDIATEc_sqlnr;--endif;EXCEPTIONWHENOTHERSTHEN/**/V_SQLERR:=SUBSTR(SQLERRM,1,255);out_code:=2out_mess:=substrb(V_SQLERR,1,1000);RAISEjb_err;END;/**/out_code:=1out_mess:=执行成功!commit;EXCEPTIONwhenjb_errthenROLLBACK;--whenothersthen--V_SQLERR:=SUBSTR(SQLERRM,1,255);out_code:=3out_mess:=V_SQLERR;ROLLBACK;--ENDtest_cjsql;有人能告诉我这段代码是什么意思么求大神指/pre>

    һƪسһͳ˶ꣿƽսҵģ

    һƪû