Clever Geek Handbook

PHP and OCI-Lob :: reading from clob oracle

I'm having a weird problem with PHP and the OCI-Lob :: read method.

We have a page that connects to the database and pulls out all the other fields without issue. However, when it comes to clobs, only a small fraction of the actual data is retrieved.

The code uses:

$content= $features[14]->read(2000);
echo $content;

And we get a tiny chunk of the field (only about 185 out of all 553 characters). The weird thing is that no matter what length is specified - it still only returns a small section and - the truncation is actually 549 bytes / characters - anything below the length specified as 549 truncates the returned string but anything over 549 doesn't matter.

In addition, we used the OCI-Lob :: load method with exactly the same results when only a portion of the actual content of the clob field is returned.

Any ideas what might be causing this?

TIA

+3


source to share


1 answer


It turns out the problem is with the connection string!



TNS_ALIAS is not configured correctly, so I hardcoded the connection string and then worked - for some bizarre reason, a minor error in the TNS_ALIAS configuration allowed some, but not all, of the clob data to be accessed.

+2


source






More articles:


All Articles