Re: Newbie -very newbie- question

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sat, 18 Sep 1999 08:54:00 +0200
Message-ID: <937637707.19851.0.pluto.d4ee154e@news.demon.nl>

sqlplus scott/tiger@<your database>
(sql prompt) create or replace procedure newbie

                    is
                    begin
                    dbms_output.put_line('Hello world');
                    end;
                    /
                   set serveroutput on size 20000
                    exec newbie
                    rem or
                    begin
                    newbie;
                    end;
                    /

If sqlplus 'doesn't work' (which is hardly to be believed) please be specific and post an exact error message.

Hth,

--
Sybrand Bakker, Oracle DBA

andreval <andreval_at_ix.netcom.com> wrote in message news:37E32F7C.AF0DB1DA_at_ix.netcom.com...
>
> Hello everyone:
> After writing the code for a PL/SQL small program. What should I do to
> make it run?
>
> I tried sqlplus but it does not work. Is there a special dedicated
> program for that?
>
> It seems that this is such a foolish question that even buying the :
> ORACLE PL/SQL I don't know yet how to make work the first example of the
>
> book.
>
> Thanks a lot
> andres
>
>
>
Received on Sat Sep 18 1999 - 01:54:00 CDT