oracle mx stored procedure

[kyle969]

"Error Executing Database Query.[Macromedia][Oracle JDBC Driver]
Incorrect parameter bindings for stored procedure call.
Check your bindings against the stored procedure's parameters

<cfstoredproc procedure="test_prc" datasource="#cmacfuser#" returncode="yes">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="#user.empNo#"
null="yes"/>
</cfstoredproc>

CREATE OR REPLACE PROCEDURE test_prc(pEmpNo IN VARCHAR2)

If i set returncode to "no" the procedure executes, but it does not receive
the value sent. I have an insert query in the proc that inserts the value and
sysdate into a test table. The date is inserted, but the variable is null.

[CF_Oracle]

Try this: <cfstoredproc procedure="test_prc" datasource="#cmacfuser#" returncode="yes">
<cfprocparam type="Inout" cfsqltype="CF_SQL_VARCHAR" variable = pEmpNo" value="#user.empNo#" null="yes"/>

[kyle969]

Still doesnt work. I removed the returncode param and it sucessfully executes, but the value is not passed to the procedure

[CF_Oracle]

Value must be in single quote since this is VARCHAR datatype.
<cfprocparam type="Inout" cfsqltype="CF_SQL_VARCHAR" variable = "pEmpNo" value= '#user.empNo#' null="yes"/>