cfstoredproc yields no response

[Sam Farmer]

This is a bizzare one.  I have a stored procedure that updates a status field as soon as it is called and when called through SQLPlus works just fine.  When I call it from ColdFusion I get neither an error message nor any indication the procedure runs.  Any ideas?

Here is the code:
<cfstoredproc procedure="SP_BLASTER_LOAD_EMAIL_TOKEN1" datasource="eismail">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="28" >
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="sysdate" >
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="sysdate" >
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="" >
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="" >
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="dual" >
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="1=1">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="143.220.161.250" >
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="sysdate">
<cfprocparam type="In" cfsqltype="CF_SQL_CHAR" variable="N" >
</cfstoredproc>

Thanks,

Sam

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---