This discussion is archived
2 Replies Latest reply: Nov 1, 2012 1:07 AM by 970843 RSS

encountered the symbol "end" when expecting one of the following

970843 Newbie
Currently Being Moderated
In the below procedure i did something wrong and im not getting where i went wrong getting "encountered the symbol "end" when expecting one of the following " Please help me and explain with wat is wrong in the procedure.

create or replace PROCEDURE CRangeproc(in_termid IN VARCHAR2,in_cardno IN VARCHAR2,p_ResultSet OUT SYS_REFCURSOR,outcount OUT NUMBER)
AS
BEGIN
select count(*) into outcount from cardrangetable where PAN_LOW <= in_cardno AND PAN_HIGH >= in_cardno and terminal_id = in_termid;
IF outCount = 1 then
Open p_ResultSet FOR
select ISSUERTABLEID,ACQUIRERTABLEID,PANLENGTH from cardrangetable where PAN_LOW <= in_cardno AND PAN_HIGH >= in_cardno and terminal_id = intermid;
CLOSE p_ResultSet;
else
end if;
End CRangeproc;

Thanks in advance

Edited by: im_asa on Nov 1, 2012 12:45 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points