Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Procedure Newbie

Re: Stored Procedure Newbie

From: John Jones <john.jones_at_duke.edu>
Date: Mon, 23 Apr 2001 10:25:52 -0400
Message-ID: <9c1dp5$hoq$1@news.duke.edu>

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...

> 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
>
>
Received on Mon Apr 23 2001 - 09:25:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US