I had incorrect information in my error in the previous two posts.
It should read:
The error: (nemisis)
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
The error occurred in D:\somepath\act_updateProgramFund.cfm: line 50
48 :
49 : <cfstoredproc procedure="#storedProc#" dataSource="databasemonster"
debug="yes" returncode="yes">
50 : <cfprocparam type="out" cfsqltype="CF_SQL_VARCHAR" dbvarname="datetext"
/>
51 : </cfstoredproc>
52 :
SQL {call FUNDING."date_text"()( (param 1) )}
DATASOURCE oracle1srvr
VENDORERRORCODE 900
SQLSTATE 42000
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338772
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
