My first PL/SQL script does not work

[l-ellison]

Hello.

I'm trying to execute my first PL/SQL script on Oracle 8i:

sqlplus system/manager @myscrypt.sql

myscript.sql:
-----------
declare
my_age NUMBER;
begin
select AGE into my_age from PUPILS where name='John';
dbms_output.put_line('AGE: ' || my_age);
end;
----------

But I get this:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
12

And the cursos blinks just after '12', but nothing happens.

What am I doing wrong?

Thank you very much.

[julian]

At the end of the script, add one more line which contains only one symbol:

/

How about now :-)

[l-ellison]

Thank you, Julian, for your answer.

I changed my script:

....
end;
/

But it still does not work. The cursor blinks after '12'.

[l-ellison]

I'm sorry.

I forgot to save my script. Now it works, but it does not print anything.

Is 'put_line' command the right one?

Thank you very much.

[julian]

Originally posted by l-ellison
I'm sorry.

I forgot to save my script. Now it works, but it does not print anything.

Is 'put_line' command the right one?

Thank you very much.

Before declare add a new/first line

set serveroutput on