Hi, DB gurus,
I have a strange problem with Oracle 9i in Java. When I execute the following JDBC call, I met
"ORA-06550:
PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320:
ORA-06550:
PL/SQL: SQL Statement ignored"
The sql is:
"{call INSERT INTO "DAY_STAT" ("ID","YEAR","MONTH","DATE","VH_CNF","INCOMING","B _L","PICKING","AREA_PICKING","IN_EXIT","TR_DOC","O T_MOVING","AREA_MOVING","IN_MOVING","OUTER_REP_DOC ","OUTER_OT_IN_REP","OUTER_OT_REP","INNER_REP_DOC" ,"INNER_REPAIRING","PDI_CHK","PDI_RIGHT","PDI_WRON G","WASHING","DAMAGE","CUS_ID","WH_ID","VH_MDL_ID" ,"VH_COLOR_ID") VALUES ("SEQ_DAY_STAT"."NEXTVAL",?,?,?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) RETURNING "ID" INTO ?}"
I think there may be something wrong with the oracle JDBC driver(I use oracle's official JDBC driver which is packed into class12.zip), becuase there are no problems when the above statement
is executed in sql plus. And if the statement is shorter, it works perfectly.
So any ideas?
Your response is highly anticipated!
Thank you in advance!

Regards,
Justine
2003-5-12