How to return a status from sqlplus to .ksh unix script ?
From: Zvika Glickman <zglickman_at_il.bphx.com>
Date: 11 Aug 2004 23:55:59 -0700
Message-ID: <b6b91e64.0408112255.3e8e7b82_at_posting.google.com>
I have a script a.ksh as follow:
Date: 11 Aug 2004 23:55:59 -0700
Message-ID: <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 ???? Received on Thu Aug 12 2004 - 08:55:59 CEST