Hi All -
In our coldfusion code, there is a cfstoredproc block in which some parameters
are being passed in. Couple of paramaters are of "out" type.
<cfstoredproc procedure="proc_save" datasource="#Application.DSN#">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
value="#FORM.FirstName#" dbvarname="p_firstName">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
value="#FORM.LastName#" dbvarname="p_lastName">
<cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR"
variable="#Form.Roll_Id#" dbvarname="p_roll_id">
<cfprocparam type="Out" variable="Variables.retval"
cfsqltype="CF_SQL_VARCHAR" dbvarname="p_retvalue">
</cfstoredproc>
In the above code, the third paramter is a out type, and the variable attribute
is surrounded by hashes. What does that mean? In some cases, the procedure
works fine, but in some cases it throws the following error
You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348950
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
