It must be passing a date from CF to raocel storedproce. but i dont know how to overcome this :(( > If it works in SqlPlus then the proc is probably ok. Since everything > is dates and strings I can't see where an error regarding a number is > coming from... > > On 2/24/06, vishnu prasad <[EMAIL PROTECTED]> wrote: > > > Is this error a CF one or an Oracle one? > > Error Reported in CF , in Stored procedure we saved the where cluse > build dynamically in aother table, when we ecexute the SQL in SQL plus > we were able to get records. But when we access the same via > <cfstoreproc> we are getting invalid number > > -- > CFAJAX docs and other useful articles: > http://jr-holmes.coldfusionjournal. com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233341 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
