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: Carlos Jose Guerrieri <carlos.guerrieri_at_realize-it.com>
Date: Tue, 18 Nov 2003 23:23:58 +0100
Message-ID: <bpe6e0$5tp$00$1@news.t-online.com>


Thank you for your answer i found now the window for the ouput.

Greetings
Carlos
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:ut6lrvoi3b7enh5g0c3dqcn6hj3uhbja2e_at_4ax.com...
> 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
Received on Tue Nov 18 2003 - 16:23:58 CST

Original text of this message

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