Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NEWBIE: Trying to run an anonymous block (PL/SQL)

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

From: DJ <nospamplease_at_goaway.com>
Date: Tue, 18 Nov 2003 22:19:35 -0000
Message-ID: <YVwub.2518$4Y6.1217@newsfep4-winn.server.ntli.net>

"Carlos Jose Guerrieri" <carlos.guerrieri_at_realize-it.com> wrote in message news:bpe4sj$k00$07$1_at_news.t-online.com...
> 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
>
>

did you put a / at the end to make it run? Received on Tue Nov 18 2003 - 16:19:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US