Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: newbie pl/sql question
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
>
> Can I run this procedure by calling: Execute InsertToBaseball at the
> command line
>
> Is there an equivalent to a DESCRIBE which i can do on procedures
>
> Thanks,
> Marc
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Hi Marc,
The table "USER_ERRORS" contains details of compilation
errors for your procedure.
At the SQL*Plus command prompt you can type
EXECUTE PROCEDURE InsertToBaseball
to run your procedure.
There will be a data dictionary table containing the text of your procedure. However, I don't recall its name.
HTH,
Avi.
Received on Mon Aug 07 2000 - 00:00:00 CDT