<cfstoredproc procedure="someProcedure" datasource="#DSN#">
     <cfprocparam value="#someValue#" cfsqltype="cf_sql_sometype"/>
     <cfprocparam type="out" variable="someVarname">
</cfstoredproc>

<cfquery name="someName" datasource="#DSN#">
     insert into SOMETABLE (name,title,cat,dog,fish)
     VALUES
     ('#somrVarname#','#someVarname# - Title',0,1,0)
</cfquery>