PLS-00103: Encountered the symbol "(" when

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
keerti_rose
Posts: 40
Joined: Sat Mar 01, 2008 3:39 pm
Location: India

PLS-00103: Encountered the symbol "(" when

Post by keerti_rose »

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>
keerti_rose
Posts: 40
Joined: Sat Mar 01, 2008 3:39 pm
Location: India

Post by keerti_rose »

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".
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests