Re: NEWBIE: Trying to run an anonymous block (PL/SQL)

On Tue, 18 Nov 2003 22:57:39 +0100, "Carlos Jose Guerrieri" <carlos.guerrieri_at_realize-it.com> wrote:

>Hi,
>
>i`m new to PL/SQL. I bought the ORACLE PL/SQL book from Feuerstein and would
>try to run some examples but i have my problems to get it run.
>I tried the following anonymous block in TOAD and i get no output. Maybe
>someone can figure out what i did wrong?
>
>DECLARE
> today DATE DEFAULT SYSDATE;
>BEGIN
> DBMS_OUTPUT.PUT_LINE ('Today is ' || today);
>END;
>
>I tried this also in SQL*PLUS but had no success too. It expect more input
>(line) after the end-statement.
>
>Thanks in advance
>Carlos Jose Guerrieri
>

you need a / on the last line.
This doesn't apply to TOAD though, and in TOAD serveroutput will end up in a separate window.

--
Sybrand Bakker, Senior Oracle DBA