Re: OCI8 Issues

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);