4 Replies Latest reply on Sep 3, 2020 12:52 PM by 4088972

    Validation Boolean function failed: Missing IN or OUT parameter at index:: 1

    4088972

      Hi

      Boolean Function validation isn't working in SQL  developer. Its erroring out  even on the sample code provided by Oracle  giving the following error Validation Boolean function failed: Missing IN or OUT parameter at index:: 1

      The sample code in Boolean validation is

      DECLARE

          l_count NUMBER;

      BEGIN

          SELECT count(*) INTO l_count FROM dual;

          IF l_count <> 0

          THEN

              RETURN TRUE;

          ELSE

              RETURN FALSE;

          END IF;

      END;