ODBC PHP / Oracle - UPDATE, INSERT, DELETE

Question

I’m in a project using PHP and Oracle. the connection is OK, with this code I can run all the selects I need normally, what I can’t run are INSERTS, UPDATES and DELETE.

Would anyone know why?

<?php
require_once('connection.php');
if($conn)
{
   $Query = "UPDATE PQAQ SET CAMINHO_ARQUIVO = 'PDF' WHERE CODIGO_PROCESSO = 18 AND CAMINHO_ARQUIVO = 'TESTE.PHP'";
   odbc_exec($conn, $Query);
}
?>

Answer 1

Some banks work in two-way transfers by default. If change (Insert/update/delete) is executed it is not 'practice' on time, it is pending until the commit.

There are two ways to solve this problem. The first is to send the commit manually with the function odbc_commit().

$Query = "UPDATE PQAQ SET CAMINHO_ARQUIVO = 'PDF' 
          WHERE CODIGO_PROCESSO = 18 AND CAMINHO_ARQUIVO = 'TESTE.PHP'";
odbc_exec($conn, $Query);

if(!odbc_commit($conn)){
    echo 'erro: '. odbc_errormsg($conn);
}

The second is to let odbc work on autocommit by default, the function odbc_autocommit() does this leave your call right after creating the connection.

odbc_autocommit($conn, true);