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>
PLS-00103: Encountered the symbol "(" when
-
- Posts: 40
- Joined: Sat Mar 01, 2008 3:39 pm
- Location: India
-
- Posts: 40
- Joined: Sat Mar 01, 2008 3:39 pm
- Location: India
Who is online
Users browsing this forum: No registered users and 0 guests