Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg:ORA-24381: error in array DML

chandra_1986Sep 16 2020 — edited Sep 16 2020

HI Experts,

We are getting below error kindly suggest wht needs to do to resolve it:

23:06:56 DBI Error => 2000000000

DBI Errstr => ORA-24381: error(s) in array DML (DBD SUCCESS_WITH_INFO: error possibly near <*> indicator at char 537 in 'INSERT INTO UFOSODRPT.HOURLY_REPORT_DC_TABLE (APPLICATION, API_DATE, API_HOUR, SO, APP, API, ACTUAL_API, ROLE, AVG_RUN, AVG_RUN_GOOD, AVG_RUN_FAIL, TOTAL_TRANS, GOOD_TRANS, FAIL_TRANS, FAIL_PERC, COUNTS_TO1, PERC_TO1, COUNTS_TO15, PERC_TO15, COUNTS_OVER15, PERC_OVER15, COUNTS_1TO5, PERC_1TO5, COUNTS_5TO10, PERC_5TO10, COUNTS_10TO15, PERC_10TO15, COUNTS_15TO30, PERC_15TO30, COUNTS_30TO60, PERC_30TO60, COUNTS_OVER60, PERC_OVER60, DATACENTER, METRIC, TZ_DATE, TZ_HOUR) VALUES ( :p1, TO_DATE(:p2,'MM-DD-YYYY'), :p3, :p4, :p5, :p6, :p7, :<*>p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21, :p22, :p23, :p24, :p25, :p26, :p27, :p28, :p29, :p30, :p31, :p32, :p33, :p34, :p35, TO_DATE(:p36,'MM-DD-YYYY'), :p37 ) ')

executing 135714 generated 9 errors

DBI State => S1000

Thanks

Comments
Post Details
Added on Sep 16 2020
14 comments
3,979 views