Cordial Greeting.
I am working on Oracle 11G from PHP and it is necessary to use some functions of ORACLE from PHP and since I am passing more than 1 query at the same time to use INSERT ALL I am sending the data in an array and using the function insert_batch CODEIGNITER.
Example query from PHP with functions.
$data = array(
1 => array("NOMBRE" => "Aberto", "APELLIDO" => "Martinez", "FEC_HOR" => "TO_DATE('11/07/2017 08:10:10','DD/MM/YYYY HH:MI:SS')"),
2 => array("NOMBRE" => "Carlos", "APELLIDO" => "Moreira", "FEC_HOR" => "TO_DATE('11/07/2017 07:30:04','DD/MM/YYYY HH:MI:SS')")
)
Which when passing from the controller to the model and executing with the aforementioned CODEIGNITER function, an error occurs and the following is displayed
INSERT ALL
INTO "REPINC" ("APELLIDO", "FEC_HOR", "NOMBRE")
VALUES ('Martinez','TO_DATE(''11/07/2017 08:10:10'',''DD/MM/YYYY HH:MI:SS'')','Aberto')
INTO "REPINC" ("APELLIDO", "FEC_HOR", "NOMBRE")
VALUES ('Moreira','TO_DATE(''11/07/2017 07:30:04'',''DD/MM/YYYY HH:MI:SS'')','Carlos') SELECT * FROM dual
When CODEIGNITER builds the query with the data that happened to him the error is evident but I have not been able to solve it.