problem with stored procedure

From: Craig Hamilton <craig_46_at_hotmail.com>
Date: 6 May 2002 16:30:13 -0700
Message-ID: <88b33d08.0205061530.6f01855_at_posting.google.com>

[Quoted] [Quoted] I am receiving compile errors with the following procedure.

The first errors are: Encountered the symbol "(" when expecting one of the following:
  :=.),_at_% default character...

Seems it is looking for defaults...are those necessary?

Any help would be much appreciated.

thanks,

craig

create or replace procedure sample(description in varchar2(125),activityid in varchar2(10),  accomplishments in float, unitofmeasure in varchar2(15),  workcomments in varchar2(4000),inYear in number(4,0),  updateuser in varchar2(15), updatetime in date ,  returnVal out number(15,0))
AS
DECLARE
    temp_recordid kcactivity.recordid%TYPE; BEGIN
    select kc_actbud_recordid.nextval into temp_recordid from dual;     

    	insert into kcactivity (description,activityid,
    				accomplishments,unitofmeasure,
    				workcomments,year,
    				updateuser,updatedate)
	values (description,activityid,
		accomplishments,unitofmeasure,
		workcomments,inYear, 
		updateuser, updatetime)

END kc_budget_activityplan_insert Received on Tue May 07 2002 - 01:30:13 CEST