http://us2.php.net/manual/en/function.ociexecute.php http://us2.php.net/manual/en/function.ocicommit.php
The optional mode allows you to specify the execution-mode (default is OCI_COMMIT_ON_SUCCESS). If you don't want statements to be committed automatically specify OCI_DEFAULT as your mode.
Unless you decide to do a ocicommit () afterwards, it's not being committed due to the OCI_DEFAULT mode.
Or maybe you could try this: $execute = ociexecute($stmt, OCI_COMMIT_ON_SUCCESS);
-- Jason k Larson
Moore, Christie wrote:
I don't receive any errors from this code but when I look in the look at the table it is not updated.
I am also receiving a Warning: _oci_open_server: ORA-12535: TNS:operation timed out. Not sure why.
I guess my question is what would make the update not change the valuse in the database but show no errors.
Thanks. $logonId = ocilogon($username, $password, $dbName);
$stmt = OCIParse($logonId, "begin U_TABLE('$portInStatus', '$portInStatusError', '$requestStatus', '$requestStatusError', '$requestNumber', '$portingNumber'); end;");
$execute = ociexecute($stmt, OCI_DEFAULT);
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
