ok so very noob of me but i had the naming of the procedure off by a few characters so it did not match up (i am programming this in the objects brower in oracle). not however i get the following errors and have no idea what to do about them:

Compilation failed,line 17 (16:14:19)
PLS-00103: Encountered the symbol "=" when expecting one of the following: constant exception table LONG_ double ref char time timestamp interval date binary national character nchar The symbol "" was substituted for "=" to continue.

Compilation failed,line 19 (16:14:19)
PLS-00103: Encountered the symbol "UPDATE" when expecting one of the following: begin function package pragma procedure subtype type use form current cursor The symbol "begin" was substituted for "UPDATE" to continue.

Compilation failed,line 33 (16:14:19)
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin case declare end exception exit for goto if loop mod null pragma raise return select update while with << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe