Good afternoon to this wonderful team at Oracle. I'm not getting through SQL COMANDS, insert more than one record has table. of database. I did all the tests, with 1 record and with 319 records, some explanation for this event.
Ex.
Insert into CLIENTES (CLIENTE_ID,NOME,ENDERECO,LIMITE_CREDITO,WEBSITE) values (187,'ConocoPhillips','Walpurgisstr 69, Munich, ',2400,'http://www.conocophillips.com');
0.01 seconds
Result for one register.
Ex: 1 row(s) inserted.
0.00 second
More one register.
Insert into CLIENTES (CLIENTE_ID,NOME,ENDERECO,LIMITE_CREDITO,WEBSITE) values (190,'3M','Via Frenzy 6903, Roma, ',1200,'http://www.3m.com');
Insert into CLIENTES (CLIENTE_ID,NOME,ENDERECO,LIMITE_CREDITO,WEBSITE) values (192,'Exelon','Via Luminosa 162, Firenze, ',500,'http://www.exeloncorp.com');
Error at line 1/166: ORA-00933: SQL command not properly ended ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 797 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_230100", line 782 ORA-06512: at "APEX_230100.WWV_FLOW_DYNAMIC_EXEC", line 2035 1. Insert into CLIENTES (CLIENTE_ID,NOME,ENDERECO,LIMITE_CREDITO,WEBSITE) values (187,'ConocoPhillips','Walpurgisstr 69, Munich, ',2400,'http://www.conocophillips.com'); 2. Insert into CLIENTES (CLIENTE_ID,NOME,ENDERECO,LIMITE_CREDITO,WEBSITE) values (190,'3M','Via Frenzy 6903, Roma, ',1200,'http://www.3m.com'); 3. Insert into CLIENTES (CLIENTE_ID,NOME,ENDERECO,LIMITE_CREDITO,WEBSITE) values (192,'Exelon','Via Luminosa 162, Firenze, ',500,'http://www.exeloncorp.com')
0.01 seconds
--Product Build 23.1.3
Schema Compatibility 2023.04.28
Patch Version 3
Last Patch Time 07/24/2023 01:13:28 AM
Last DDL Time 07/24/2023 01:11:49 AM
Host Schema APEX_PUBLIC_USER
Application Owner APEX_230100
Workspace ID 60183732850381496338
Workspace Name JOULIUM
Current User JOULIUMPROCESS@GMAIL.COM
Language Preference en
Current Time (on server) 08/01/2023 02:35:49 PM +00:00
CGI Environment
APEX_LISTENER_VERSION 23.1.2.r1151944
PLSQL_GATEWAY WebDb
GATEWAY_IVERSION 3
SERVER_SOFTWARE Mod-Apex
GATEWAY_INTERFACE CGI/1.1
SERVER_PORT 443
SERVER_NAME apex.oracle.com
REQUEST_METHOD GET
QUERY_STRING session=13133273152519&dialogCs=kPkaXIugWH-kwG7_KMH5ursXATstrh7U7w1MfwjfBXhqCN2ELdW5vUIVss0to_QYowQDH_wtGVupTcPVdkC0Qw
PATH_INFO /about
SCRIPT_NAME /pls/apex/r/apex/workspace-admin
REMOTE_ADDR 127.0.0.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_PROTOCOL https
REMOTE_USER APEX_PUBLIC_USER
HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36
HTTP_HOST apex.oracle.com
HTTP_ACCEPT_ENCODING gzip
HTTP_ACCEPT_LANGUAGE en-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7
HTTP_ORACLE_ECID
WEB_AUTHENT_PREFIX
DAD_NAME
DOC_ACCESS_PATH
DOCUMENT_TABLE
PATH_ALIAS
REQUEST_CHARSET AL32UTF8
REQUEST_IANA_CHARSET UTF-8
SCRIPT_PREFIXstou conseguindo inserir mais de uma linha através da linha de comand