Seem to have been finally cracked. The problem was not the code but Oracle. Turns out that anything you do, especially from a client (was using TOAD), must be committed. Otherwise, you will delete rows or truncate table yet the rows will still remain I suppose.. Somehow, the 'uncommitted' activities will will make your life a little difficult. Case in point, I do a select in code which returns rows, then do a select in toad and will not.. same table same db. So where are these rows returned in code coming from?? That was until I began to do the commit thanks to some advise from a DBA. That was my conclusion. On Thu, Feb 6, 2014 at 5:54 PM, Samuel Waithaka <samwaithaka@gmail.com>wrote:
Moses,
I got slightly different results with your search than I was getting. It's helping but haven't made much head-way; I'm still hopeful. I was thinking there's a common known problem but I have found nothing yet..
On Thu, Feb 6, 2014 at 5:30 PM, Moses M.G <mouzmuyer@gmail.com> wrote:
Answer ndio hii http://bit.ly/1ndfs4G
On 6 February 2014 16:35, Samuel Waithaka <samwaithaka@gmail.com> wrote:
Hi everyone,
I could use some help here; has anyone executed an insert statement into Oracle using PHP?
I have done a select but insert won't work at all, either through the classic way, or using PDO.
It shows activity forever, but doesn't throw any error. However, if there's say a syntax error in the SQL, it is quickly picked. What could I be missing.
Will appreciate some help.
-- Samuel Waithaka http://twitter.com/samwaithaka
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Kind Regards,
Moses M.G.
_______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Samuel Waithaka http://twitter.com/samwaithaka
-- Samuel Waithaka http://twitter.com/samwaithaka