2 Replies Latest reply: Nov 1, 2012 3:07 AM by 970843 RSS

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

    970843
      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