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
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.
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
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
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
Kennedy, so what you're saying is that the different sessions lock on each other? The 'unlocking' happens after commit? On Fri, Feb 7, 2014 at 5:36 PM, Kennedy Kairu Kariuki <kkairu@gmail.com>wrote:
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
-- Samuel Waithaka http://twitter.com/samwaithaka
lf you doing an insert in one session you'll only see the results in the other after commit. On 2/7/14, Samuel Waithaka <samwaithaka@gmail.com> wrote:
Kennedy, so what you're saying is that the different sessions lock on each other? The 'unlocking' happens after commit?
On Fri, Feb 7, 2014 at 5:36 PM, Kennedy Kairu Kariuki <kkairu@gmail.com>wrote:
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
-- Samuel Waithaka http://twitter.com/samwaithaka
-- Regards, Kennedy KK Mobile: +254751110168 Skype: k.kairu Gtalk: kkairu
participants (3)
-
Kennedy Kairu Kariuki -
Moses M.G -
Samuel Waithaka