[PHP-DB] Oracle NClobs

2011-08-05 Thread N . A . Morgan
Guys, Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. The following piece of code works with a CLOB, but not with an NCLOB. Can anyone shed any light please? $SQL = " UPDATE $d_sid.srs_spd SET spd_fuld = EMPTY_CLOB() WHERE spd_stuc = :stuc AND spd_seqn = :seqn

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Lester Caine
n.a.mor...@brighton.ac.uk wrote: Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. It may not be related, but there were a number of issues with BLOB ids in Firebird which were not fixed until 5.2.7, I don't have anything that old running now, but I think that it was not

RE: [PHP-DB] Oracle NClobs

2011-08-05 Thread N . A . Morgan
Lester, Thanks for the advice, I tried to run this on a 5.2.17 install as well with the same results. Thanks anyway, Neil -Original Message- From: Lester Caine [mailto:les...@lsces.co.uk] Sent: 05 August 2011 17:08 To: php-db@lists.php.net Subject: Re: [PHP-DB] Oracle NClobs n.a.mor..

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Christopher Jones
On 08/05/2011 09:08 AM, Lester Caine wrote: n.a.mor...@brighton.ac.uk wrote: Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. It may not be related, but there were a number of issues with BLOB ids in Firebird which were not fixed until 5.2.7, I don't have anything tha

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Christopher Jones
On 08/05/2011 08:55 AM, n.a.mor...@brighton.ac.uk wrote: Guys, Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. The following piece of code works with a CLOB, but not with an NCLOB. Can anyone shed any light please? There is no support for NCLOB in PHP OCI8. Chr

[PHP-DB] Insert query error

2011-08-05 Thread Chris Stinemetz
I am getting the following error trying to run the below query. Any suggestions on what I am doing wrong? Thank you, Something went wrong while inserting your store visitCannot add or update a child row: a foreign key constraint fails (`store`.`posts`, CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`post