Question

Java sql batch exception

{"status":"1","message":"数据上传错误：StatementCallback; uncategorized SQLException for SQL [insert into INT_INTERVIEW_PERSON (sub_id,person_id,site_id,score,absent_flag) values (SYS_GUID(),\u002711111\u0027,\u00271111\u0027,\u002780\u0027,\u0027否\u0027)]; SQL state [99999]; error code [29900]; ORA-29900: 运算符连接不存在\nORA-06553: PLS-306: 调用 \u0027SCORE\u0027 时参数个数或类型错误\n; nested exception is java.sql.SQLException: ORA-29900: 运算符连接不存在\nORA-06553: PLS-306: 调用 \u0027SCORE\u0027 时参数个数或类型错误\n","result":""}
String sql3 = "insert into INT_SCORE_RESULT_DETAIL (detail_id,item_id,score) values (SYS_GUID(),'"
+problemResultProbolemID+"','"+problemResultResult+"')";

Answer 1

\u002711111\u0027,\u00271111\u0027,\u002780\u0027,\u0027否\u0027

\可能需要转义~~