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:21:53 +0100
Message-ID: <bpe6a2$qo3$08$1@news.t-online.com>


Hi,

thanks with the / it now works in SQL*PLUS, ig get the message that the procedure is executed successfully but i do not get an output.

Greetings
Carlos

"DJ" <nospamplease_at_goaway.com> schrieb im Newsbeitrag news:YVwub.2518$4Y6.1217_at_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:21:53 CST

Original text of this message

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