DBMS_OUTPUT.PUT_LINE problem.

From: Vidya <vmswar2_at_yahoo.com>
Date: Mon, 7 Jan 2008 11:26:04 -0800 (PST)
Message-ID: <99df0ea6-f329-46bb-bcd3-2b932fa30343@v4g2000hsf.googlegroups.com>

Hi,
I am trying to execute my newly created 'Login' stored procedure. For some reasons I get error on dbms_outout.put_line line code. Can someone look into the block below and tell me what the problem is...? Below is the version, code and error msg. Any help is greatly appreciated.

---beginin of the code -----
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> SET SERVEROUTPUT ON
SQL>
SQL> declare

  2 iid number;
  3 PRSS number;
  4 RETMES varchar2(200);
  5 begin
  6 WEB_GMX_MANAGEMENT.Login(
  7 'vms',
  8 '4111',
  9 iid,
 10 PRSS,
 11 RETMES);
 12 end;

 13   DBMS_OUTPUT.PUT_LINE(iid);
 14   DBMS_OUTPUT.PUT_LINE(PRSS);
 15   DBMS_OUTPUT.PUT_LINE(RETMES);

 16 /
 DBMS_OUTPUT.PUT_LINE(iid);
 *
ERROR at line 13:

ORA-06550: line 13, column 2:
PLS-00103: Encountered the symbol "DBMS_OUTPUT"
ORA-06550: line 13, column 27:
PLS-00103: Encountered the symbol ";" when expecting one of the

following:
. ( , * % & - + / at mod rem <an identifier>
<a double-quoted delimited-identifier> <an exponent (**)> as
from into || bulk
ORA-06550: line 15, column 30:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:
begin case declare end exception exit for goto if loop mod null pragma raise return select update while with
<an identifier> <a double-quoted

• end of code-----

Best Regards,
Vidya Received on Mon Jan 07 2008 - 13:26:04 CST