Re: sqlplus/sqlnet PL/SQL block errors

John Hough wrote:
>
> 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
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> 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.

Oh yeah! The scripts work fine when run on the machine locally!

John Hough Received on Fri Feb 14 1997 - 00:00:00 CST