For all DML you need to commit to be able to view the results in a
different session. The toad client and PHP code initiate different
sessions.

On 2/7/14, Samuel Waithaka <samwaithaka@gmail.com> wrote:
> 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
>

--


Regards,

Kennedy KK

Mobile: +254751110168
Skype: k.kairu
Gtalk: kkairu

_______________________________________________
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