>> returncode="yes">
>
>> What's with the param 1 in front of the call? then another
>> param 2??
>
>A complete guess from a non-Oracle person, but ... could it be for the return 
>code?

Ok, I've removed returncode and debug and now have the following.

<cfstoredproc procedure="#storedProc#" dataSource="bigdatabasemonster">
        <cfprocparam type="out" cfsqltype="CF_SQL_VARCHAR" dbvarname="datetext" 
/>
</cfstoredproc> 

Returns:
SQL   {call P3DEVELOPER."date_text"()( (param 1) )} 

All the rest is the same error. 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338771
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to