RE: [PHP] Oracle Commits SOLVED

2006-06-22 Thread Jay Blanchard
[snip] did the execute actually succeed? does the data get into the DB if you use OCI_COMMIT_ON_SUCCESS instead of OCI_DEFAULT? I don't support using oci_internal_debug() gives you any extra info? [/snip] I finally did an oci_bind_by_name and then performed the commit. It worked. Oci_internal_de

Re: [PHP] Oracle Commits

2006-06-22 Thread Jochem Maas
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 Oracle > with PHP as follows; > > $udGeocode = oci_parse($conn, "UPDATE CONT_ADDRESS SET GEOCODE = > '".$geocode[0]."'

[PHP] Oracle Commits

2006-06-22 Thread Jay Blanchard
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 Oracle with PHP as follows; $udGeocode = oci_parse($conn, "UPDATE CONT_ADDRESS SET GEOCODE = '".$geocode[0]."' WHERE CONTRACT_ID = '".$row[0]."' AND