Xref: alice comp.databases.oracle.server:69320 Path: alice!news-feed.fnsi.net!oleane!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!newshub.bart.net!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: Help with PL/SQL Date: Mon, 11 Oct 1999 06:44:16 +0200 Message-ID: <939617062.19288.0.pluto.d4ee154e@news.demon.nl> References: <7tquf9$j4d$1@nnrp1.deja.com> Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 939617062 pluto:19288 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 43 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 wrote in message news:7tquf9$j4d$1@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.