Good afternoon and salutations denizens of the greatest list generated
by electrons!
I have a situation where I am trying to commit a transaction in
with PHP as follows;
$udGeocode = oci_parse($conn, "UPDATE CNT_ADDRESS SET GECDE =
'".$geocode[0]."' WHERE CNTRACT_ID = '".$row[0]."' AND PSTAL_CDE =
'".$RW[1]."' AND ADDRESS_TYPE = 'S'");
oci_execute($udGeocode, CI_DEFAULT);
// commit
$committed = oci_commit($conn);
if (!$committed) {
$error = oci_error($conn);
echo 'Commit failed. reports: ' . $error['message'];
} else {
echo ' Commit succeeded';
}
The commit returns as successful, but it is not successful in the
database itself. Am I missing something here? I have RTFM on oci_execute
and oci_commit and cannot find anything
Thanks!

Jay Blanchard wrote:
Good afternoon and salutations denizens of the greatest list generated
by electrons!

I have a situation where I am trying to commit a transaction in
with PHP as follows;

$udGeocode = oci_parse($conn, "UPDATE CNT_ADDRESS SET GECDE =
'".$geocode[0]."' WHERE CNTRACT_ID = '".$row[0]."' AND PSTAL_CDE =
'".$RW[1]."' AND ADDRESS_TYPE = 'S'");
oci_execute($udGeocode, CI_DEFAULT);

did the execute actually succeed? does the data get into the DB if you
use CI_CMMITN_SUCCESS instead of CI_DEFAULT?

I don't support using oci_internal_debug() gives you any extra info?

// commit
$committed = oci_commit($conn);
if (!$committed) {
$error = oci_error($conn);
echo 'Commit failed. reports: ' . $error['message'];
} else {
echo ' Commit succeeded';
}

The commit returns as successful, but it is not successful in the
database itself. Am I missing something here? I have RTFM on oci_execute
and oci_commit and cannot find anything

Thanks!