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.
 

_______________________________________________
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