Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Procedure Newbie
If you are getting "complied with errors" then there is some syntax or other problem with the procedure. Try compling again and right after you get the error, type "show err". It will tell you where the problems is.
-- John Jones Senior Oracle DBA Duke University, OIT john.jones_at_duke.edu Rich Rans <rich_rans_at_yahoo.com> wrote in message news:3ae465eb.0_at_nntp.tfvs.tp.edu.tw...Received on Mon Apr 23 2001 - 09:25:52 CDT
> When i try to create a stored procedure, i get a message that says the
> procedure was compiled with errors. When I try to execute the procedure i
> get 'SYS.procedureName is not a valid object. I know the procedure do not
> have syntax error as they are very basic and copied from a book.
>
> I believe i have to run Dbmsstdx.sql prior to creating procedures. I did
> this and it seems to have executed properly.
>
> Any hints on how to debug this.
>
> Thanks
>
>