>> 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