Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie pl/sql question

Re: newbie pl/sql question

From: Stefan Jahnke <q5665841_at_bonsai.fernuni-hagen.de>
Date: 2000/08/07
Message-ID: <398DE7A7.B03613BF@bonsai.fernuni-hagen.de>#1/1

Steve Davidson wrote:
>
> marc bautis wrote:
>
> > I tried running the following script at a sqlplus command line
> >
> > CREATE OR REPLACE PROCEDURE InsertToBaseball AS
> >
> > v_HITTER varchar2(255) := 'John';
> > v_PITCHER varchar2(255) := 'Richard';
> >
> > BEGIN
> >
> > INSERT INTO baseball(batter, pitcher) values (v_HITTER, v_PITCHER);
> >
> > END InsertToBaseball;
> >
> > when i execute this i get a message saying Warning: Procedure created
> > with compilation errors.
> >
> > Does this mean that the procedure was created? How can I get a more
> > detailed message of what the compilation errors were
> >
>
> Yes. But it failed compilation. Issue the command 'show err' from the
> sql prompt. It will give you the reason for the compile error.
>
> > Can I run this procedure by calling: Execute InsertToBaseball at the
> > command line
>
> Yes....You need to modify your syntax to pass parameters.
> execute InsertToBaseball(parm1, parm2);
>
> >
> >
> > Is there an equivalent to a DESCRIBE which i can do on procedures
>
> don't know...sorry.
>
> >
> >
> > Thanks,
> > Marc
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Hi, in case you want to check out your procedures/functions, you can always use a direct "SELECT * FROM user_source". That shows the source code for the actual schema you're in. But I would recommend to use tools for that (at least OEM Schema Manager) since the SQL*PLUS output is always shi... formatted, unless you spend some time to make it look nicer.

regards
Stefan Received on Mon Aug 07 2000 - 00:00:00 CDT

Original text of this message

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