Hi,
I'm using Oracle Apex 22.2.3. I'm trying to insert values from external database into Oracle APEX. When I insert one row everything is fine, but the problem is when I try to insert multiple lines. I got an error: Error at line 2/3: ORA-00933: SQL command not properly ended.
Sample data provided below:
Insert into XX_COMPANY (ID,ACCESS_CHOSEN,ADDRESS,CAPTION,CONTACT_PERSON,DELETE_DATE,EMAIL,NAME,NIP,PHONE,SAP_ID,UNIT,UPDATE_DATE) values ('207','1','SXXXXX 4 43-100 Tychy','RPW',null,null,null,'RPW i K 6460010321 ','6460010321',null,'205271','NT02,NT07,NT66,NT87,NT88',to_timestamp('21/01/17 23:34:50.000000000','RR/MM/DD HH24:MI:SSXFF'));
Insert into XX_COMPANY (ID,ACCESS_CHOSEN,ADDRESS,CAPTION,CONTACT_PERSON,DELETE_DATE,EMAIL,NAME,NIP,PHONE,SAP_ID,UNIT,UPDATE_DATE) values ('208','1','W 12c 40-389 Katowice','HMNS ...',null,null,null,'HMNS','6340197361',null,'205272','NT02,NT07,NT87,NT88',to_timestamp('21/01/17 23:34:50.000000000','RR/MM/DD HH24:MI:SSXFF'));
Insert into XX_COMPANY (ID,ACCESS_CHOSEN,ADDRESS,CAPTION,CONTACT_PERSON,DELETE_DATE,EMAIL,NAME,NIP,PHONE,SAP_ID,UNIT,UPDATE_DATE) values ('209','1','KXXXXX 32-620 BRZESZCZE','GMINA BRZESZCZE',null,null,null,'GMINA BRZESZCZE','5492197471',null,'205273','NT02,NT07,NT66,NT87,NT88',to_timestamp('21/01/17 23:34:50.000000000','RR/MM/DD HH24:MI:SSXFF'));
Thank you