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

On Jan 7, 1:26*pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
You've placed the DBMS_OUTUT code AFTER the end; for the block. It
should be before:

declare
iid number;
PRSS number;
RETMES varchar2(200);
begin
WEB_GMX_MANAGEMENT.Login(
'vms',
'4111',
iid,
PRSS,
RETMES);
DBMS_OUTPUT.PUT_LINE(iid);
DBMS_OUTPUT.PUT_LINE(PRSS);
DBMS_OUTPUT.PUT_LINE(RETMES);
end;
/


David Fitzjarrell

On Jan 7, 1:26*pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
You've placed the DBMS_OUTUT code AFTER the end; for the block. It
should be before:

declare
iid number;
PRSS number;
RETMES varchar2(200);
begin
WEB_GMX_MANAGEMENT.Login(
'vms',
'4111',
iid,
PRSS,
RETMES);
DBMS_OUTPUT.PUT_LINE(iid);
DBMS_OUTPUT.PUT_LINE(PRSS);
DBMS_OUTPUT.PUT_LINE(RETMES);
end;
/


David Fitzjarrell

On Jan 7, 1:26*pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
You've placed the DBMS_OUTUT code AFTER the end; for the block. It
should be before:

declare
iid number;
PRSS number;
RETMES varchar2(200);
begin
WEB_GMX_MANAGEMENT.Login(
'vms',
'4111',
iid,
PRSS,
RETMES);
DBMS_OUTPUT.PUT_LINE(iid);
DBMS_OUTPUT.PUT_LINE(PRSS);
DBMS_OUTPUT.PUT_LINE(RETMES);
end;
/


David Fitzjarrell

On Jan 7, 1:26*pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
You've placed the DBMS_OUTUT code AFTER the end; for the block. It
should be before:

declare
iid number;
PRSS number;
RETMES varchar2(200);
begin
WEB_GMX_MANAGEMENT.Login(
'vms',
'4111',
iid,
PRSS,
RETMES);
DBMS_OUTPUT.PUT_LINE(iid);
DBMS_OUTPUT.PUT_LINE(PRSS);
DBMS_OUTPUT.PUT_LINE(RETMES);
end;
/


David Fitzjarrell

On Jan 7, 7:26 pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
btw this is one of the advantages of formatting your code - this type
of thing would leap out at you. It's much harder to spot in a random
jumble.

On Jan 7, 7:26 pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
btw this is one of the advantages of formatting your code - this type
of thing would leap out at you. It's much harder to spot in a random
jumble.

On Jan 7, 7:26 pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
btw this is one of the advantages of formatting your code - this type
of thing would leap out at you. It's much harder to spot in a random
jumble.

On Jan 7, 7:26 pm, Vidya <vmsw... (AT) yahoo (DOT) com> wrote:
btw this is one of the advantages of formatting your code - this type
of thing would leap out at you. It's much harder to spot in a random
jumble.

On 8 Jan., 09:27, William Robertson <williamr2... (AT) googlemail (DOT) com>
wrote:
And it's pretty easy, there are even formatters on the web that work
well for small amounts of code:

http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm
http://www.orafaq.com/utilities/sqlformatter.htm

Cheers

robert