Function returning error texts in Oracle APEX

Question

I am trying to take a count of the records in the interactive grid and based on that I am trying to pass a message to the user. However, I am getting error : ORA-06550: line 1, column 141: PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following: := . ( @ % ; The symbol "." was substituted for "NUMBER" to continue.Following is my code in the validation. Validation Type is : Function Returning Error Text.

l_count NUMBER := 0;

BEGIN

  SELECT COUNT(1)
      INTO l_count
      FROM  ugh
     WHERE ugh.pre = :PRE
       AND ugh.APP1 = :APP1
       AND ugh.APP2 = :APP2
       AND ugh.APP3 = :APP3
       AND ugh.FINL_APP = :FINL_APP;
 
IF l_count > 1 THEN
      IF END_DATE IS NULL THEN
         RETURN 'Error Message to be displayed.';
      ELSE
      RETURN NULL;
      END IF;
    ELSE
     RETURN NULL;
   END IF;
END;

Can anyone please help ?

Littlefoot · Accepted Answer · 2022-11-23 13:09:21Z

1

Looks like you're missing the DECLARE keyword:

DECLARE                           --> this
   l_count  NUMBER := 0;
BEGIN
   SELECT COUNT (1)
     INTO l_count
     FROM ugh

Also, what is END_DATE? You never declared it. If it is a page item, then precede it with a colon, :END_DATE

answered Nov 23, 2022 at 13:09

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Function returning error texts in Oracle APEX

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related