PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

Alberto Viana's Blog: Zend Framework and Oracle XMLType

Note: This article was originally published at PHPDeveloper on 22 September 2011.
PHPDeveloper

Alberto Viana has a new post to his blog about using Oracle ZML Types with a Zend Framework application. He created a custom adapter to create the type and handle the binding/execution on an new OCI8 connection.

So few days ago I needed to insert Oracle XMLtype with Zend Framework. I used oracle adapter to wrote it in Zend Framework. I was looking for and I found on Chris Jones Blog.

His table has a column defined as an XMLType, a special data type specifically for working with XML datasets directly in the database. His adapter includes a bit of sample XML and the code needed to bind the data as a CLOB and, using the writeTemporary function.