Stored Procedure Newbie

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 Sun Apr 22 2001 - 21:31:40 CDT