Why won't this work? All the datatypes are correct, and in the CORRECT order.
It seems to be hanging up on the OUT parameter at the end

It gives me the following error
Error Executing Database Query.
[DataDirect][SequeLink JDBC Driver]Syntax error at token 0, line 0 offset 0.

166 : <CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_TIMESTAMP" VALUE="#TERMDATE#"
DBVARNAME="@TermDate" NULL="YES">
167 : <CFPROCPARAM TYPE="OUT" CFSQLTYPE="CF_SQL_INTEGER" DBVARNAME="@EFTId"
VARIABLE="EFTId">
168 : </CFSTOREDPROC>
169 :
170 : </cfquery>

SQL
DATASOURCE ASSURANTTEST
VENDORERRORCODE 6036
SQLSTATE 42000

<CFSTOREDPROC PROCEDURE="SPEM_M_INSERTUPDATEEFTCREDITCARD" DATASOURCE="#DSN#"
DEBUG="YES">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE=""
DBVARNAME="@eftcreditcardid" NULL="YES">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#SSN#"
DBVARNAME="@SSN">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR"
VALUE="#CREDITCARDNUMBER#" DBVARNAME="@AcctNum">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#lastname#"
DBVARNAME="@LastName">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#firstname#"
DBVARNAME="@FirstName">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="#initial#"
DBVARNAME="@Initial">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#homephone#"
DBVARNAME="@HomePhone">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#workphone#"
DBVARNAME="@WorkPhone">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#bankname#"
DBVARNAME="@BankName">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#branch#"
DBVARNAME="@Branch">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#address#"
DBVARNAME="@Address">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#city#"
DBVARNAME="@City">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="#state#"
DBVARNAME="@State">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#zip#"
DBVARNAME="@Zip">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#routingnum#"
DBVARNAME="@RoutingNum">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="P"
DBVARNAME="@AcctType">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_TIMESTAMP" VALUE="10/19/2005"
DBVARNAME="@SignDate">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="Y"
DBVARNAME="@Signed">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#ccname3#"
DBVARNAME="@NOCLastName">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#ccname#"
DBVARNAME="@NOCFirstName">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="#ccname2#"
DBVARNAME="@NOCInitial">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="#expdate#"
DBVARNAME="@ExpDate">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="#CID#"
DBVARNAME="@LastThree">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE="1"
DBVARNAME="@Status">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE="#persnameid#"
DBVARNAME="@PersNameId">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE="#NAMEONCARDID#"
DBVARNAME="@NameOnCardId" NULL="YES">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#AGENTNUM#"
DBVARNAME="@AgentNum" NULL="YES">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE="#JULIANDT#"
DBVARNAME="@JulianDt" NULL="YES">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_INTEGER" VALUE="#BSN#"
DBVARNAME="@BSN" NULL="YES">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_CHAR" VALUE="#DCN#"
DBVARNAME="@DCN" NULL="YES">
<CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_TIMESTAMP" VALUE="#TERMDATE#"
DBVARNAME="@TermDate" NULL="YES">
<CFPROCPARAM TYPE="OUT" CFSQLTYPE="CF_SQL_INTEGER" DBVARNAME="@EFTId"
VARIABLE="EFTId">
</CFSTOREDPROC>