| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.oracle -> 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,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 - 01:55:59 CDT
 |
 |