Re: newbie pl/sql question

Answers embedded
You are aware all manuals are online at
http://technet.oracle.com ?

Just a hint...

Regards,

Sybrand Bakker, Oracle DBA

"marc bautis" <bautisma_at_bigfoot.com> wrote in message news:8mkee5$l9n$1_at_nnrp1.deja.com...
> 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?
Yes, with compilation errors, so it won't work

 How can I get a more
> detailed message of what the compilation errors were
>

show errors
or
select * from user_errors where name = 'INSERTTOBASEBALL' (the mixed case will not survive)

> Can I run this procedure by calling: Execute InsertToBaseball at the
> command line
>

 No, because there are errors
> Is there an equivalent to a DESCRIBE which i can do on procedures
>

The equivalent is called describe.

> Thanks,
> Marc
>
>
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Aug 06 2000 - 00:00:00 CDT