469,927 Members | 1,897 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

How to return a status from sqlplus to .ksh unix script ?

I have a script a.ksh as follow:

[vashti]<orasp> cat a.ksh
sqlplus -s rsi/rsi < aaa1.sql
echo stat $?
[vashti]<orasp>

text of aaa1.sql:

exec dbms_stats.gather_table_stats
('P0E1A00','MI_AC_CIRBE_GEN',cascade=>true,estimat e_percent=>25);

Problem: how can i transfer the status of the execution of
dbms_stats.gather_table_stats to the .ksh ????
Jul 19 '05 #1
2 14664
zg*******@il.bphx.com (Zvika Glickman) wrote in message news:<b6**************************@posting.google. com>...
I have a script a.ksh as follow:

[vashti]<orasp> cat a.ksh
sqlplus -s rsi/rsi < aaa1.sql
echo stat $?
[vashti]<orasp>

text of aaa1.sql:

exec dbms_stats.gather_table_stats
('P0E1A00','MI_AC_CIRBE_GEN',cascade=>true,estimat e_percent=>25);

Problem: how can i transfer the status of the execution of
dbms_stats.gather_table_stats to the .ksh ????


Z, look up the SQLPlus command "whenever sqlerror exit FAILURE"

Many times all you need to pass back to the shell is success or
failure. For the exact problem you can look at the spool file.

In the case of a dmbs_stats I would generally not expect a failure
message.

HTH -- Mark D Powell --
Jul 19 '05 #2
zg*******@il.bphx.com (Zvika Glickman) wrote in message news:<b6**************************@posting.google. com>...
I have a script a.ksh as follow:

[vashti]<orasp> cat a.ksh
sqlplus -s rsi/rsi < aaa1.sql
echo stat $?
[vashti]<orasp>

text of aaa1.sql:

exec dbms_stats.gather_table_stats
('P0E1A00','MI_AC_CIRBE_GEN',cascade=>true,estimat e_percent=>25);

Problem: how can i transfer the status of the execution of
dbms_stats.gather_table_stats to the .ksh ????


Thanks mark,
I used:
whenever sqlerror exit sql.sqlcode;
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Vincento Harris | last post: by
4 posts views Thread by Raj Kotaru | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.