Re: Help with PL/SQL

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 11 Oct 1999 06:44:16 +0200
Message-ID: <939617062.19288.0.pluto.d4ee154e@news.demon.nl>

A small example, to be run in Sql*Plus
sqlplus > create or replace procedure dummy(p_name in varchar2) is

            > -- declarations of variables go here,unnecessary this time
            > begin
            > dbms_output.put_line(p_name); -- do not forget to issue set
serveroutput on
            > end;
            > /
sqlplus > procedure created

sqlplus > set serveroutput on
sqlplus > begin

            > dummy('Hello world');
            > end;
            > /

sqlplus > Hello world

etc, etc,

Hth,

--
Sybrand Bakker, Oracle DBA
jamesk447 <jamesk447_at_my-deja.com> wrote in message news:7tquf9$j4d$1_at_nnrp1.deja.com...
> Could someone tell me how to enter and save PL/SQL files? I'm not
> having any trouble with SQLPlus but I can't do much without the
> procedural aspect of PL/SQL. Does it matter which editor I use to write
> the PL/SQL code? How is the code compiled? A separate program that
> maybe I didn't download with Personal Oracle8 ? Where do I save it? How
> do I invoke it ( With a START command at the SQL> prompt? ) This
> approach will not even run the sample files that came with it. It gives
> errors about lack of declarations of variables. The documentation does
> not say how to run the PL/SQL programs, just how to write them. Someone
> please shed some light on this for me. I've looked around and can't
> find this info anywhere. Thanks, jamesk
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 10 1999 - 23:44:16 CDT