Posted by Christopher.Jones on 05/30/06 23:55

Mladen Gogala <gogala@sbcglobal.net> writes:

> On Sat, 20 May 2006 23:49:22 +0000, Mladen Gogala wrote:
>
> > The latest version of OCI8 1.2.1 doesn't work with LOB fields. There was
> > an open bug, but Tony2001 was his usual helpful self, so he removed the
> > bug and flatly denied its existence. I had to download 1.2.0 and reading
> > CLOB fields started working again. Unfortunately, DBMS_METADATA.GET_DDL
> > returns CLOB, so I was forced to discover this non-existing bug. PECL
> > bug system is useless and maintainers are more suited for inquisitors then
> > for programmers. Did anybody else have a problem? If anybody was able to
> > resolve this problem, I'd like to know the solution?
> > The bug that was open and then denied was open for PHP 4.4 and I
> > experienced it with PHP-5.1.4. The native OCI8 that comes with PHP-5.1.4
> > also has the same problem. Please, let me know if anybody else has
> > experienced the problem and how.
>
> There is a patch published for this problem. This was quick.

It was a variable size issue. Pointers to 4 byte numbers were being
passed to an Oracle routine expecting 8 bytes. This caused random
behavior so it is no wonder Antony couldn't reproduce it.

Oracle's LOB development team spotted the code error.

Chris

--
Christopher Jones, Oracle Corporation, Australia.
Email: Christopher.Jones@oracle.com
Blog: http://blogs.oracle.com/opal/

[Back to original message]