linux shell 执行存储过程,在shell中调用执行存储过程

基本的shell文件结构如下：

sqlplus user/password <

exec proc_name;

exit

!

Demo

procedure name: sp_ems_hasten_count(v_oper_date in varchar2)

.sh file               : execpro.sh

[oracle@localhost tmp]$ cat -v execpro.sh

sqlplus post_kf/post_kf << !

exec sp_ems_hasten_count('20090415');

exit

!

select count(1) from ems_hasten_count;

COUNT(1)

0

[oracle@localhost tmp]$ ./execpro.sh

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 4月 27 13:33:28 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

select count(1) from ems_hasten_count;

COUNT(1)

18531