We're getting the Oracle error ORA-24334: no descriptor for this position with the following query. Not having much luck finding out what's going on, or getting info from the MM CF forum, CF-Talk archives, or Google. Any ideas? (CF 4.5.1 SP2 on Solaris 8, Oracle 8i db, with 8.1.7 client)
thanks, Chris Norloff SELECT job_id, provider_code, NVL(financial_no, '00000') financial_no, mailing_facility, job_title, process_category, class, local_permit_no, permit_type, total_piece, total_weight, cqt_total_pieces, cqt_weight, location_zip, owner_name, gca_version FROM m_job_summary WHERE job_id = 'QD2AES_1' AND provider_code = 'QUAD' AND mailing_facility = '22203-1553' Oracle's description of the error: ORA-24334 no descriptor for this position Cause: The application is trying to get a descriptor from a handle for an illegal position. Action: Check the position number. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
