ORA:00933 sql command not properly ended

[SREESHAK]

i am getting the erroe ORA:00933 sql command not properly ended ,for

sqlStatement.ex ecuteUpdate(
"INSERT INTO CLARITY.Z_INBOU ND_AUTO_SCHEDUL E(FILE_NAME, FILE_DATE, CREATED_DATE, MODIFIED_DATE, PROCESS_STATUS, ID)"
+ " VALUES ('" + str1 + "','" + str2 + "', SYSDATE, SYSDATE, 0, z_inbound_auto_ schedule_s1.nex tval)"
+ " WHERE NOT EXISTS (SELECT 1 FROM CLARITY.Z_INBOU ND_AUTO_SCHEDUL E"
+ " WHERE FILE_NAME = '" + str1 + "'"
+ " AND FILE_DATE = '" + str2 + "')");
can anyone help please
sree

[debasisdas]

What is that WHERE clause in INSERT INTO statement.

[amitpatel66]

i am getting the erroe ORA:00933 sql command not properly ended ,for

sqlStatement.ex ecuteUpdate(
"INSERT INTO CLARITY.Z_INBOU ND_AUTO_SCHEDUL E(FILE_NAME, FILE_DATE, CREATED_DATE, MODIFIED_DATE, PROCESS_STATUS, ID)"
+ " VALUES ('" + str1 + "','" + str2 + "', SYSDATE, SYSDATE, 0, z_inbound_auto_ schedule_s1.nex tval)"
+ " WHERE NOT EXISTS (SELECT 1 FROM CLARITY.Z_INBOU ND_AUTO_SCHEDUL E"
+ " WHERE FILE_NAME = '" + str1 + "'"
+ " AND FILE_DATE = '" + str2 + "')");
can anyone help please
sree

WHERE CLAUSE cannot be used in case if you are using INSERT INTO...VALUES.

WHERE CLAUSE can be used with INSERT INTO...SELECT * FROM.....