Sorry about that :
Release 9.2.0.1.0 - Production on Fri Feb 21 12:53:24 2003
(c) 1982, 2002, Oracle Corporation. All rights reserved.
I tried leaving a blank line and now i get the following msg:
Enter value for numbrows: 5
old 2: numbrows NUMBER (2) := '&numbrows';
new 2: numbrows NUMBER (2) := '5';
DBMS_OUPUT.PUT_LINE (last_dept_table(i).last_name||' '||last_dept_table(i).dept_id||' '||dept_
*
ERROR at line 27:
ORA-06550: line 27, column 7:
PLS-00201: identifier 'DBMS_OUPUT.PUT_LINE' must be declared
ORA-06550: line 27, column 7:
PL/SQL: Statement ignored
Quote:
Originally posted by andrewst
No, I don't. As I said, I DON'T get the error when I run the same script in SQL Plus 8.0.5.0.0
NOTE: I'm talking about the SQL PLUS version here, not the Oracle version. I mean the very top banner:
Code:
SQL*Plus: Release 8.0.5.0.0 - Production on Fri Feb 21 16:47:22 2003
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Try leaving a blank line between the SET SERVEROUTPUT ON command and the DECLARE. At the moment your SQL Plus seems to think the SET command is an invalid part of the PL/SQL block, whereas my version manages to recognise it as a separate SET command.
|