How do i call Oracle function from Coldfusion

How do i call oracle function from Coldfusion using cfstoredproc.
Below is my oracle function:

FUNCTION Get_Load_Lock (pm_source IN VARCHAR2) RETURN BOOLEAN

IS
v_lock  SNDSV_REF_CODES.rv_high_value%TYPE;

BEGIN
    BEGIN
            SELECT rv_high_value INTO v_lock
            FROM SNDSV_REF_CODES
            WHERE rv_domain = 'E-EKSAIS'
            AND rv_type = 'CONTROL'
            AND rv_low_value = 'LOCK - '||pm_source
            AND record_status = 'E'
            FOR UPDATE OF rv_high_value NOWAIT;

            ROLLBACK;

      EXCEPTION WHEN OTHERS THEN
        v_lock := 'Y';
      END;

      IF v_lock = 'N' THEN
          RETURN TRUE;
      ELSE
          RETURN FALSE;
      END IF;

END Get_Load_Lock;

Note: pm_source = PAYMENT.
shakkerAsked:
Who is Participating?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.