ORA-01722: Invalid Number, ORA-12801

SQL:

Select

/* + Parallel (A, 32) */a. ID

, A. data_date

, A. mobile_num

, A. mobile_code

, B. prov as mobile_prov

, B. City as mobile_city

, B. mobile_oper

, A. PSAM

, A. psam_code

, C. detail_type

, C. busi_type

, C. sum_type

, A. trancde

, D. trans_name

, D. lv4_name

, D. lv3_name

, D. lv2_name

, D. lv1_name

, D. lv0_name

, A. merno

, A. outcdno

, A. outcdno_bin

, E. card_name as outcdno_name

, E. card_type as outcdno_type

, E. card_type_name as outcdno_type_name

, E. bank_name as out_bank_name

, E. bank_short_name as out_bank_short_name

, A. incdno

, A. incdno_bin

, F. card_name as incdno_name

, F. card_type as incdno_type

, F. card_type_name as incdno_type_name

, F. bank_name as in_bank_name

, F. bank_short_name as in_bank_short_name

, A. s_no

, A. terminal_area

, A. terminal_id

, A. pro_no

, A. n_platform

, A.org _ id

, A. pay_state

, A. pay_respns

, A. trans_respns

, A. de37

, A. is_sucess

, A. total_am

, A. pro_am

, A. free_am

From EDW. dw_fact_trans partition (dw_month_201303)

Left join EDM. d_mobile_info B

On a. mobile_code = B. mobile_code

Left join EDM. d_psam_card_info C

On a. psam_code = C. psam_ AB _head

Left join EDM. d_trancde_info d

On a. trancde = D. trans_code

Left join EDM. d_cardinfo_apply E

On a. outcdno_bin = E. card_bin

Left join EDM. d_cardinfo_apply F

On a. incdno_bin = f. card_bin;

Error message:

Select

*

Error at line 1:

The ORA-12801: Error signaled in parallel query server P003, instance db1: db1 (1)

ORA-01722: Invalid Number.

Cause analysis:

There is a comparison between characters and numbers.

Solution:A. mobile_code = to_char (B. mobile_code)

ORA-01722: Invalid Number, ORA-12801