Hello,
I have a stored procedure and just added a new data validation check. However, now when I try to compile I get the following error code. Any help is much appreciated. Thanks
"Error(103,6): PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following: begin case declare else elsif end exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe "
Here is the SQL
pErrorCode := 0;
SELECT PROJECT_OWNER INTO pClarityProjectOwner FROM CBW_PROJECT_NUMBERS WHERE PROJECT_OWNER = pClarityProjectOwner AND STATUS = 'Open';
EXCEPTION
WHEN NO_DATA_FOUND THEN
pClarityProjectOwner := 0;
pErrorCode := 1;
IF pErrorCode = 0 THEN
SELECT NVL(CBW_PROJECT_NUMBERS.PROJECT_GROUP,0) INTO pClarityProjectGroup FROM CBW_PROJECT_NUMBERS,CBW_PROJECT_GROUP
WHERE (CBW_PROJECT_NUMBERS.PROJECT_GROUP = CBW_PROJECT_GROUP.PROJECT_GROUP)
AND (CBW_PROJECT_NUMBERS.PROJECT_OWNER = pClarityProjectOwner)
AND (LOWER(CBW_PROJECT_NUMBERS.PROJECT_TYPE) = 'bcn')
AND (LOWER(CBW_PROJECT_GROUP.PROJECT_CATEGORY) = 's')
AND (LOWER(CBW_PROJECT_NUMBERS.STATUS) ='open'); (error is right here) EXCEPTION
WHEN NO_DATA_FOUND THEN
pClarityProjectGroup := 0;
pErrorCode := 2;
END IF;
Here is e.g.
Open in new window