shakker
asked on
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_va lue%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.
Below is my oracle function:
FUNCTION Get_Load_Lock (pm_source IN VARCHAR2) RETURN BOOLEAN
IS
v_lock SNDSV_REF_CODES.rv_high_va
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.