 | | | Oracle + Unix question , Error validation for SQL statements in " "coprocess " " ?. | Oracle + Unix question , Error validation for SQL statements in " "coprocess " " ?. 2004-07-20 - By Ranjeesh K R.
Hi,
Thanks a lot for your responses . But somehow people mis understood my =
question, I was asking about if i "implement co process " to the =
following code what to do for error validations . for eg :..a sample =
test code
for the following code=20
sqlplus -s uid/pwd |&
print -p "whenever OSERROR exit 1; "
print -p "whenever SQLERROR exit 2; "
echo $? "sql " > > /home/etladm/test/out.txt
print -p "select sysdate into datval from dual; "
echo $? "xxx " > > /home/etladm/test/out.txt
print -p "select sysdate into datval from dual; " > > =
/home/etladm/test/out.txt
echo $? "select " > > /home/etladm/test/out.txt
echo $datval "value " > > /home/etladm/test/out.txt
print -p "exit "
while read -p LINE # Get the co-process output
do
print - ${LINE}
echo ${LINE} > > /home/etladm/test/out.txt
done
output is
0sql
0 xxx
0select
value
select sysdate into datval from dual
cop.ksh find.txt grep.txt out.txt out.txt:w wi040625.xml
ERROR at line 1:
ORA-00905 (See ORA-00905.ora-code.com): missing keyword
all are zero , even though it is getting errored out. Any idea on how to =
resolve this?. This is just a test code , I want to implement "co =
process " with error validation for the following code.
with thanks and regards=20
Ranjeesh K R=20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
Hi,
If I use co process in a shell script , what is the best way to do the =
error validation of the execution of any sql statements . I was trying =
to change the following code to make use of co process concept. When I =
tried echo $? after the execution of a "wrong statements "
it is still giving Zero output ( meaning success)=20
< < < < < < < < < < < < < < < < < < < < < < < < < < <
cat ${CFG_DIR}/srs_indx.lst | egrep -v '^# ' | egrep -v '^[ ]*$ ' | =
while read x
do
..
echo " Processing values :: pre $pre tbl $tbl indx $indx tblspc $tblspc =
cols $cols param $param " > > ${LOGS_DIR}/srs_indx.log
sqlplus ${BIZSTG} < < EOT > > ${LOGS_DIR}/srs_indx.log
set verify on timing on term on echo on feedback on serveroutput on
WHENEVER SQLERROR CONTINUE
drop index $indx;
WHENEVER SQLERROR EXIT FAILURE
alter session set query_rewrite_enabled =3D true;
create $pre index $indx on $tbl ($cols)
tablespace $tblspc
$param;
exit
EOT
RC=3D$?
if ( test $RC -ne 0 )
then
ERR_MSG=3D "ERROR in creating index $indx for table $tbl from =
srs_indx.ksh of $ENVIR : $APP by `whoami`@`hostname` on `date` "
echo $ERR_MSG > > ${LOGS_DIR}/srs_indx.log
process_warning ${LOGS_DIR}/srs_indx.log
exitstat=3D1
else
echo "$indx created at `date` " > > ${LOGS_DIR}/srs_indx.log
fi
done =20
> > > > > > > > > > > > > > > > > > > >
Any help will be appreciated .
with thanks and regards=20
Ranjeesh K R=20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|