 | | RE: WHENEVER SQLERROR EXIT SQL.SQLCODE||SQLERRM & Relate ORA-ERRN
O & SQLCODE | RE: WHENEVER SQLERROR EXIT SQL.SQLCODE||SQLERRM & Relate ORA-ERRN
O & SQLCODE 2004-07-22 - By Jeroen van Sluisdam
Hi,
Just catch the error in your sql and print the errormessage. This will come
on standard output and
this can catched into an file or variable
sqlplus .... > > filename
if [[ $? -ne 0 ]] then
echo "SQLPLUS failed " $?
cat filename
Regards,
Jeroen
-- --Oorspronkelijk bericht-- --
Van: Ranjeesh K R. [mailto:ranjeeshk@(protected)]
Verzonden: Wednesday, July 21, 2004 4:35 PM
Aan: undisclosed-recipients; LOCAL
Onderwerp: WHENEVER SQLERROR EXIT SQL.SQLCODE||SQLERRM & Relate ORA-ERRNO &
SQLCODE
Hi,
Qn 1
-- -----
Is there any way to pass both the SQL.SQLCODE & SQLERRM to the os back ??
Qn 2
-- ----
When I tried WHENEVER SQLERROR EXIT SQL.SQLCODE
The actual oracle error code (ORA-00942 (See ORA-00942.ora-code.com)) and the error code (174 ) returned
by SQL.SQLCODE are different . So how can I get the info. that is related to
SQL.SQLCODE
eg :
For this test program
-- ---- ---- ---- ------
rm -f /home/etladm/test/test.log
sqlplus -S < <EOF > > /home/etladm/test/test.log
ranjeeshk/ics
set verify on time on timing on term on echo on feedback on serveroutput on
WHENEVER SQLERROR EXIT SQL.SQLCODE
-- WHENEVER SQLERROR EXIT SQLERRM
select sysdate sdate from dua;
exit 1
EOF
echo "Number of rows are: $? " > > /home/etladm/test/test.log echo " -- -----
Log file -- ----- \n " cat /home/etladm/test/test.log
The output was
-- ---- ---- ---- -----
etladm@(protected):/home/etladm/test >. ./test.ksh
-- ----- Log file -- -----
select sysdate sdate from dua
*
ERROR at line 1:
ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist
Number of rows are: 174
etladm@(protected):/home/etladm/test >
So how can I link ORA-00942 (See ORA-00942.ora-code.com) and SQLCODE 174 ?
with thanks in advance
Ranjeesh K R
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|