Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Not Getting The Error..

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US