I'm not sure that this is the problem, but could the following be causing a
cyclical redundancy error:
NVL(financial_no, '00000') financial_no
Some DB platforms don't let you assign an alias name that is the same as the
column to which it is being assigned.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----Original Message-----
> From: Chris Norloff [mailto:cnorloff@;norloff.com]
> Sent: Friday, October 18, 2002 9:39 AM
> To: CF-Talk
> Subject: Oracle Error "no descriptor for this position
>
>
> 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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
