Are you using a stored proceedure or a referential cousor? Cold Fusion likes IN variables to have a value of some sort for each varable.
The code would look like the following:
<cfstoredproc procedure="sp_myproceedure" datasource="mydatasource" returncode="no">
<cfprocparam type="in" dbvarname="myvarname_from_oracle" value="#myvalue#" cfsqltype="CF_SQL_VARCHAR">
.... and so on
</cfstoredproc>
You also have three in parameters for sysdate and one for dual. Those are internal oracle variables. Was that intentional? Are those suppose to be out parameters?
P.S. Are you living in NOVA area these days?
Jeremy Brodie
Intelix
an Edgewater Technology Solutions Company
web: http://www.edgewater.com
phone:(703) 815-2500
nasdaq symbol: EDGE
> 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]
