internal SP's are named, naming them this way WILL slow access to the
SP, and in theory could be causing other issues.
Try renaming the proc to 'spBLASTER_LOAD_EMAIL_TOKEN1', you could also
try making the SP retrun a value or recordset and dump it.
-----Original Message-----
From: Sam Farmer [mailto:[EMAIL PROTECTED]
Sent: 04 December 2003 14:56
To: CF-Talk
Subject: cfstoredproc yields no response
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]
