Re: Stored Procedure Newbie

A couple of comments:

1. Use the command 'show error procedure <procedure_name>' to see why your procedure doesn't compile.
2. Your message implies that you are logged in as SYS. You should create a proper user account and use that. Here's a simple script to get you started.

create user scott identified by tiger

   default tablespace users
   temporary tablespace temp;

grant create session, resource to scott; revoke unlimited tablespace from scott;
alter user scott quota 10m on users;

Jared

Rich Rans wrote:

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

-- 
Jared Still
jkstill_at_cybcon.com