devNyong
[ORACLE] java.sql.SQLSyntaxErrorException: ORA-00905 본문
I am trying to insert data into an existing table and keep receiving an error.
This happens because my typo
my error code
<insert id="insert">
<foreach collection="arr" item="item" open="INSERT ALL" close="SELECT * FROM DUAL" separator=" ">
INSERT INTO TEST_TABLE(
ID
, ITEM_VALUE
) VALUES (
#{item.id}
, #{item.value}
)
</foreach>
</insert>
solution : REMOVING THE INSERT
<insert id="insert">
<foreach collection="arr" item="item" open="INSERT ALL" close="SELECT * FROM DUAL" separator=" ">
INTO TEST_TABLE(
ID
, ITEM_VALUE
) VALUES (
#{item.id}
, #{item.value}
)
</foreach>
</insert>
'error' 카테고리의 다른 글
Comments