newbie pl/sql question

From: marc bautis <bautisma_at_bigfoot.com>
Date: 2000/08/06
Message-ID: <8mkee5$l9n$1@nnrp1.deja.com>#1/1

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. Received on Sun Aug 06 2000 - 00:00:00 CDT