Hey all, Got a query and one of the columns is returning a 'varray' from Oracle... course when I run the query in CF, I am getting the following error....
'unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag' I am assuming that this is caused by the 'varray' return from Oracle (think it is using nested tables) because when I remove this column, all is fine How do I deal with it? Any Oracle SQL Functions I can wrap the column in to produce a string/list or something I can use? I have tried TO_CHAR but it just gives an invalid data conversion error (or similar, can't remember exactly).... TIA David ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
