Not Getting The Error..

From: Ariji Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 24 Feb 2005 21:50:45 -0800
Message-ID: <1109310645.907714.151430@z14g2000cwz.googlegroups.com>

DEAR ALL,

---

--PACKAGE DETAILS------------------------

SQL> CREATE OR REPLACE PACKAGE PKG_CATEGORY   2 IS

  3     FROM_PROC BOOLEAN := FALSE;
  4     NUMBER_OF_BLOG NUMBER(10,0) := 0;

  5 END;
  6 /

Package created.

--PROCEDURE DETAILS
SQL> CREATE OR REPLACE PROCEDURE PROC_CATEGORY_TRANS_DATA_DELETE(B_ID NUMBER,C_ID NUMBER)
  2 AS
  3 BEGIN
  4 DECLARE

  5     TOTAL_COUNT NUMBER(10,0);
  6     BEGIN
  7             SELECT COUNT(*) INTO TOTAL_COUNT FROM CATEGORY_TRANS
WHERE BLOG_ID = B_ID AND CATEGORY_ID = C_ID;
  8             IF (TOTAL_COUNT = 1) THEN
  9                     RAISE_APPLICATION_ERROR(-20001,'SINGLE RECORD
FOUND');
 10             ELSIF
 11                     PKG_CATEGORY.FROM_PROC := TRUE;
 12                     PKG_CATEGORY.NUMBER_OF_BLOG := TOTAL_COUNT;
 13                     DELETE FROM CATEGORY_TRANS WHERE BLOG_ID = B_ID
AND CATEGORY_ID = C_ID;
 14             END IF;
 15     END;

 16 END;
 17 /

Warning: Procedure created with compilation errors.

SQL> SHOW ERRORS
Errors for PROCEDURE PROC_CATEGORY_TRANS_DATA_DELETE: /c clsLINE/COL ERROR

---

---

11/27 PLS-00103: Encountered the symbol "=" when expecting one of the

         following:


         . ( * @ % & = - + < / > at in mod not rem then

         <an exponent (**)> <> or != or ~= >= <= <> and or like
         between is null is not || is dangling
         The symbol "then was inserted before "=" to continue.

================

THESE IS MY CODE DETAILS.BUT I COULDN'T ABLE TO FIND OUT THE ERROR. PLEASE HELP ME OUT.
REGARDS
ARIJIT CHATTERJEE Received on Thu Feb 24 2005 - 23:50:45 CST