sqlplus/sqlnet PL/SQL block errors

From: John Hough <q6y_at_ornl.gov>
Date: 1997/02/14
Message-ID: <330497E4.4A5D@ornl.gov>#1/1

I am getting a strange error when connecting from a RS600 running Oracle 7.1 to a VMS machine also running 7.1. Basically what I am doing is shown below:

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

cosdev$ sqlplus
SQL*Plus: Release 3.1.3.7.1 - Production on Fri Feb 14 11:27:12 1997

Enter user-name: accountname_at_sqlnetalias Enter password:

Connected to:
Oracle7 Server Release 7.1.3.2.0 - Production Release With the distributed option
PL/SQL Release 2.1.3.2.0 - Production

Welcome to the VAX/Oracle prod database

SQL> set echo on
SQL> start temp.sql
SQL> set heading on
SQL>
SQL> column libcache format 99.99 heading 'Library Cache Miss Ratio (%)'
#############################################################

Library Cache Check
Goal: <1%
*
Corrective Action: Increase shared_pool_size
Write identical SQL statements SQL> remark Oracle DBA Survival Guide, Sams Pub., Tuning Scripts SQL> SQL> select sum(reloads)/sum(pins) *100 libcache 2 from v$librarycache 3 /

Library Cache Miss Ratio (%)

                         .84

SQL> DECLARE
  2      v_libper number;
  3  BEGIN
  4      select sum(reloads)/sum(pins) * 100
  5      into   v_libper
  6      from   v$librarycache;
  7
  7      if v_libper > '&&1' then
  8          dbms_output.put_line(' ');
  9          dbms_output.put_line('Library Cache Check exceeded!!!');
 10          dbms_output.put_line(' ');
 11      end if;

12
12 END;
13 /
Enter value for 1: 1

old   7:     if v_libper > '&&1' then
new   7:     if v_libper > '1' then

DECLARE
*

ERROR at line 1:
ORA-06550: line 0, column 0:
PLS-00103: Message 1 not found; No message file for product=SLAX, facility=pls

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Anybody have an idea why the anonymous pl/sql blocks are not working against databases on a OpenVMS machine. We run these scripts across sqlnet against NT and other Unix boxes without problem.

HELP!!! John Hough
NCI Information Systems, Inc. Received on Fri Feb 14 1997 - 00:00:00 CST