Oracle INSERTs failing, but no errors

[eluser]jabbett[/eluser]
No luck with that. I'm trying to execute the query with PHP but completely outside CodeIgniter, and I'm encountering similar problems. I've discovered that my INSERT will work if I do a commit at the end, a la:

Code:

$c = OCILogon('USERNAME', 'PASSWORD', '//localhost/XE');
$q = 'INSERT INTO logins (userid, datein, sessionid, ipaddress) VALUES (\'abcd\', \'123\', \'1234\', \'127.0.0.1\')';

$stid = OCIParse($c, $q);
$r = oci_execute($stid, OCI_DEFAULT);

OCICommit($c);

OCILogoff($c);

I'm now hunting for a way to automatically commit with each execute.