Re: problem with stored procedure

The error is caused by the parantheses after your procedure parameters. You do not need these. So, description in varchar2(125), should read: description in varchar2

"Craig Hamilton" <craig_46_at_hotmail.com> wrote in message news:88b33d08.0205061530.6f01855_at_posting.google.com...
> 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 Wed May 08 2002 - 02:12:34 CEST