04 2012 档案

oracle_plsql_out_parametes

摘要：前天，调用plsql过程出错，今天测试了一下oracle plsql 的out 参数：测试用例： CREATE OR REPLACE PROCEDURE zp_for_test(in_month NUMBER,v_err OUT VARCHAR2) IS BEGIN ---- END zp_for_test;测试结果：Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 Connected as hbkf_crmSQL> exec zp_for_test(201203,'');begi 阅读全文

posted @ 2012-04-23 11:19 Alex-Zeng 阅读(1317) 评论(0) 推荐(0)