I m getting an error ORA-24334: no descriptor for this position while executing a query.When that query is run through SQL it runs fine but while used as source query in ODBC stage gives the above mentioned error.
The error code says : The application is trying to get a descriptor from a handle for an illegal position.
Action: Check the position number.
What is this position number and how to check?
The query is
SELECT/*+ full (s_jwsf_sales_ordr) parallel(s_jwsf_sales_ordr,4 */ --+ INDEX(C, PS_JWS_F584201T_0)
j_document_no, j_order_type_srccd, j_order_co, a.j_bus_unit_srccd,
j_customer_srccd, j_date_ordered, j_dt_sched_pick, j_dt_promised_ship,
j_date_actual_ship, j_date_cancelled, j_date_invoice, j_date_requested,
j_dt_orig_promised, j_gross_order_amt, j_extended_price,
j_extended_cost, j_freight, j_bas_gross_ordamt, j_bas_extend_price,
j_bas_extend_cost, j_bas_freight, j_hold_status,
TO_CHAR (j_dt_act_ship_dt, 'YYYY-MM-DD HH24:MI:SS'),
TO_CHAR (j_date_ordered_dt, 'YYYY-MM-DD HH24:MI:SS'),
j_order_status_id, j_fulfill_stat_id, j_base_currency, j_curr_factor,
j_ship_to_number, d.j_prod_line_srccd, j_ticket_number, --j_qtslsp,
j_delivered_flag, j_cod_flag, j_document_no_org, J_ORDER_TYPE_SRCCD_ORG,J_CAD_CONV_RATE, a.J_PAYMENT_INSTR_SRCCD, a.J_MODE_OF_TRANSPORT,J_QUOTE_PO,J_PROJECT_NUMBER,J_SHCO,
nvl(J_OAADD1,' ') OAADD1, nvl(J_OAADD2, ' ') OAADD2
FROM ps_jwsf_sales_ordr a
left outer join PS_JWS_F584201T c on a.J_DOCUMENT_NO = c.J_QTDOCO and a.J_ORDER_TYPE_SRCCD = c.J_QTDCTO
left outer join PS_JWD_BUS_UNIT d on a.J_BUS_UNIT_SRCCD = d.J_BUS_UNIT_SRCCD
left outer join PS_JWS_F4006 e on a.J_DOCUMENT_NO = e.J_OADOCO and a.J_ORDER_TYPE_SRCCD = e.j_OADCTO and a.J_ORDER_CO = e.J_OAKCOO
ORA-24334: no descriptor for this position
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Tue Aug 25, 2009 12:53 am
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia