Could not figure out whats wrong with my sql statement - ado

Question

Hi,

I have an Insert Statement in VB

strSTMT = "INSERT INTO TABLE_ONE (T_NUM, T_BATCH_ID,CREATE_DATE,LAST_UPDATE_DATE) " & _

"SELECT '" & iStoreNum & "', T_BATCH_ID,SYSDATE,SYSDATE FROM Tbl_BATCH a" & _

" WHERE T_BATCH_TYPE = 'C'" & _

" AND T_BATCH_AUTO_ASSIGN = 'Y'" & _

" AND NOT EXISTS (SELECT ROWID FROM TABLE_ONE b WHERE T_NUM = " & iStoreNum & _

" AND a.T_BATCH_ID = b.T_BATCH_ID )"

whenever i tried to execute the statement, it throws exception :

ORA-06550: line 1, column 351:

PL/SQL: ORA-00933: SQL command not properly ended

ORA-06550: line 1, column 7:

PL/SQL: SQL Statement ignored

I took the same Statement and executed in Oracel SQL developer tool,

It does not throws any error.