Full PL/SQL Programs

Hi,

I have rtfm'ed and I can not find an example of a full PL/SQL 2.0 program that runs in the SQL*PLUS environment. Specifically, I want to be able to write a program that consists of a single main routine and a few procedures and functions.

For example:

    procedure xyz is

       n number ;
    begin

       n := 1 ;
    end ;
    begin

       xyz ;
    end ;

when I try to run this I get a syntax error on the first line.

Can you write such a program?????

Thanks,

alan

--

+=============================================================+


| Alan Rosenthal :O)                     email ahr_at_biosym.com |

| Management Information Systems         vmail 619-597-9732   |


| Biosym Technologies                    fax   619-458-0136   |


 +-------------------------------------------------------------+


|        The thinking that got us where we are today          |


|       will not get us where we want to go tommorrow         |


+-------------------------------------------------------------+

--
*******************************************************************************
* DISCLAIMER: Unless indicated otherwise, everything in this note is          *
* personal opinion, not an official statement of Biosym Technologies, Inc.    *
*******************************************************************************