OSF/1, sqlplus + shell status
Date: 1995/05/26
Message-ID: <3q5drl$dnd_at_gatekeeper.cognos.com>#1/1
The following little test returns non-zero when I run sqlplus on several of our UNIX machines (aix,hpux,sunos,sco,hpux,dgux etc) but NOT on OSF/1. I'm waiting for my support group to get a call into Oracle and wondered if this rings a bell with someone.
#! /bin/csh
setenv ORACLE_HOME /isv/oracle/7.0
setenv ORACLE_PATH /isv/oracle/7.0
set path=($path $ORACLE_PATH/bin)
sqlplus user/passwd_at_taurus7v2 << EOF
whenever sqlerror exit sql.sqlcode
begin
raise value_error;
end;
.
/
EOF
echo "status was set to $status"
BTW, here is the output when run on SunOS followed by OSF/1.
SQL*Plus: Release 3.1.3.2.1 - Production on Fri May 26 16:21:53 1995
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
Connected to:
ORACLE7 Server Release 7.0.16.4.0 - Production
With the procedural, distributed, and Parallel Server options
PL/SQL Release 2.0.18.1.0 - Production
SQL> SQL> 2 3 4 SQL> begin
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 2
Disconnected from ORACLE7 Server Release 7.0.16.4.0 - Production
With the procedural, distributed, and Parallel Server options
PL/SQL Release 2.0.18.1.0 - Production
status was set to 102
SQL*Plus: Release 3.1.3.2.1 - Production on Fri May 26 16:29:01 1995
Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.
Connected to:
ORACLE7 Server Release 7.0.16.4.0 - Production
With the procedural, distributed, and Parallel Server options
PL/SQL Release 2.0.18.1.0 - Production
SQL> SQL> 2 3 4 SQL> begin
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 2
Disconnected from ORACLE7 Server Release 7.0.16.4.0 - Production
With the procedural, distributed, and Parallel Server options
PL/SQL Release 2.0.18.1.0 - Production
status was set to 0
-- Nigel Campbell Voice: (613) 738-1338 ext 3016 P.O. Box 9707 Business Intelligence FAX: (613) 738-0002 3755 Riverside Dr. Cognos Incorporated MCI: nigel campbell || 3074729 Ottawa, Ontario nigelc_at_cognos.COM CANADA K1G 3Z4Received on Fri May 26 1995 - 00:00:00 CEST