newbie question on procedures

From: Jim Lyons <godzilla_at_seuss.cc.utexas.edu>
Date: 1996/02/05
Message-ID: <1996Feb5.164932_at_seuss.cc.utexas.edu>#1/1

I am trying to create a procedure but cannot. Below is a very simple version of my procedure at the output.

Here is the source file:

---

drop procedure testproc;

create procedure testproc as
begin

        select count(*) from risk;
end;
/

---

Here is what happens when I try to execute the source file:

---

SQL> _at_testproc

Procedure dropped.

Warning: Procedure created with compilation errors.

---

Here is what happens when I try to execute the procedure:

---

SQL> exec testproc
begin testproc; end;

      *
ERROR at line 1:

ORA-06550: line 1, column 7: 
PLS-00905: object TESTPROC is invalid 
ORA-06550: line 1, column 7: 
PLS-00313: 'TESTPROC' not declared in this scope 
ORA-06550: line 1, column 7: 

PL/SQL: Statement ignored

---

What am I doing wrong? Also, why can't I get any better error messages than "Warning: Procedure created with compilation errors."?

Thanks.

--
Jim Lyons                     |  Operating Systems Specialist
Computation Center            |  512-475-9331
University of Texas at Austin |  j.lyons_at_cc.utexas.edu
http://www.cc.utexas.edu/~godzilla/jimlyons.html

Received on Mon Feb 05 1996 - 00:00:00 CET