oracle带参数的存储过程的执行

 来源：网络/责编：编程入门 作者：不详
<script src="http://www.bianceng.cn/js1/468.js"></script>

<script src="http://www.bianceng.cn/js1/300.js"></script> <script type="text/javascript"><!-- google_ad_client = "pub-1762970342420142"; /* 300x250 */ google_ad_slot = "2904782163"; google_ad_width = 300; google_ad_height = 250; //--> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/expansion_embed.js"></script> <script src="http://googleads.g.doubleclick.net/pagead/test_domain.js"></script> <script>window.google_render_ad();</script>

　　　　SQL> create or replace procedure jl_test
2 (a in varchar2,b out varchar2)
3 as
4 begin
5 b:= a;
6 end;
7 /
SQL> var c varchar2(10);
SQL> exec jl_test('01',:c)
PL/SQL 过程已成功完成。
SQL> print c
C
--------------------------------
01

　　在java中调用存储过程用的是call ps_name