OSF/1, sqlplus + shell status

From: Nigel Campbell <nigelc_at_Cognos.COM>
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 3Z4
Received on Fri May 26 1995 - 00:00:00 CEST

Original text of this message