Pls help me how to write coldfusion procedure to calling oracle function.

this is 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;

p/s: pm_source=PAYMENT


Below is my cf program:
<cfstoredproc procedure="GET_LOAD_LOCK" datasource="#dsntest#" returncode="yes">
<cfprocparam type="IN" variable="pm_source" dbvarname="PM_SOURCE" value="PAYMENT" cfsqltype="CF_SQL_VARCHAR" >
<cfprocparam type="OUT" variable="pm_lock" dbvarname="V_LOCK" cfsqltype="cf_sql_varchar">
</cfstoredproc>

error occurred:

Diagnostics : ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC driver for Oracle]Syntax error or access violation

SQL = "GET_LOAD_LOCK"
Data Source = "VSALES3"

thx ya...