News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Chris Jones' Blog:
Inserting and Updating Oracle XMLType columns in PHP
July 13, 2009 @ 08:14:21

All of you Oracle users out there might want to check out this recent post from Chris Jones, especially if you've been using the XMLType columns in your tables.

Today a reader mailed me about manipulating XMLType columns when the data is longer than the 4K limit that character-type handling imposes. My free book (see sidebar) has examples of how to do this using CLOB handling in PHP. I noticed that my xmlinsert.php example in the book does a SELECT and UPDATE, but never actually does an INSERT.

To correct the problem of the missing example he includes example code to connect to the database, push the XML into a bind variable and select the row back out to ensure everything's still structured correctly. You need to set up a new descriptor for the insert to work (CLOB).

0 comments voice your opinion now!
clob column xmltype xml oracle insert


blog comments powered by Disqus

Similar Posts

Gennady Feldman's Blog: Installing Oracle Instant Client 11g and PECL OCI8 (Part 2)

Paul Stamatiou's Blog: How To: Parse XML with PHP5

Matthew Weir O'Phinney's Blog: mbstring comes to the rescue

Chris Jones' Blog: Which OCI8 DLL to use in PHP 5.3

php|architect\'s ART: JSON and PHP - More Than Web Services


Community Events











Don't see your event here?
Let us know!


composer package facebook security framework language hhvm introduction hack application symfony2 overview opinion release podcast database install unittest component performance

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework