Possible cause for ORA-00932 parsing error with KOKBF$ (Doc ID 1406502.1)

Last updated on FEBRUARY 25, 2015

Applies to:

PL/SQL - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

MERGE INTO po_status_base d
USING
(select trunc(rowadddt,'DD') time_id, abepoid, sellerid vendor_id, status
FROM table(ABEDBA.po_cdc_pkg.po_chg(p_job_name=>'read_order_status', p_dml_type=>Null))
) S
ON (d.vendor_id = s.vendor_id
and d.po_Id = s.abepoid
and d.create_date = s.time_id
)
WHEN MATCHED THEN
UPDATE
SET d.status = s.status
WHEN NOT MATCHED THEN
INSERT (CREATE_DATE, po_id, VENDOR_ID, STATUS)
VALUES (S.TIME_ID, s.abepoid, S.vendor_id, s.status);
/

ORA-00932: inconsistent datatypes: expected NUMBER got ABEDBA.SYS_PLSQL_2923099_340_1

can be reproduced with:

SELECT distinct TBL$OR$IDX$PART$NUM("PO_STATUS_BASE", 0, 1, 0, "CREATE_DATE") FROM (SELECT TRUNC(VALUE(KOKBF$),'fmdd') "CREATE_DATE" FROM TABLE("ABEDBA"."PO_CDC_PKG"."PO_CHG"("P_JOB_NAME"=>'read_order_status',"P_DML_TYPE"=>NULL)) "KOKBF$") ORDER BY 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms