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

zglickman_at_il.bphx.com (Zvika Glickman) wrote in message news:<b6b91e64.0408112255.3e8e7b82_at_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,estimate_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; Received on Tue Aug 17 2004 - 13:30:25 CEST