ERPstuff - Oracle EBS Community

Hi Friends

When I am compiling the folwing procedure I am getting the below error which is in bold letters

Can any one go through this and let me know
Pls find the code for procedure

CREATE OR REPLACE procedure basket
(
P_Feature_id in SEQ_ID_GENERATOR.Feature_id%TYPE
,P_region_id in SEQ_ID_GENERATOR.region_id%TYPE
,P_seq_date in SEQ_ID_GENERATOR.Seq_date%TYPE
,P_sequence out SEQ_ID_GENERATOR.Latest_seq_no%TYPE
,p_concatenate out VARCHAR2(100)
,p_flag out BOOLEAN
)
as
begin
p_flag := False;
select Latest_seq_no
into P_sequence
from SEQ_ID_GENERATOR
where Feature_id=P_Feature_id
and region_id=P_region_id
and Seq_date=P_seq_date;

update SEQ_ID_GENERATOR
set Latest_seq_no=P_sequence+1;
p_flag := True;
If p_flag=ture then
p_concatenate :=P_Feature_id||
P_region_id||
08||
Num_Days(P_seq_date)||
P_sequence;
end if;
exception
when others then
p_flag := False;
DBMS_output.put_line ('Error has Occured while getting the values from SEQ_ID_GENERATOR');
END;
/
<b>PLS-00103: Encountered the symbol "(" when expecting one of the
following:
:= . ) , @ % default character
The symbol ":=" was substituted for "(" to continue.</b>

Hi Friends I got the Solution...

Nothing..... in SQL* Plus The below code will not work at Procedure Parameters Instead of this "p_concatenate out VARCHAR2(100)"
We have to use "p_concatenate out VARCHAR2".