?
Solved

PHP Oracle display CLOB

Posted on 2003-03-26
3
Medium Priority
?
348 Views
Last Modified: 2013-12-12
I wonder if anyone can help.

I am connecting to a oracle database via php, using PHP OCI functions.  I am using OCIFetchInto to get out the field from the database via a database class.  The problem I am having is displaying CLOBS, everything else gets pulled out the database ok, but where a CLOB field is shown, I just see the text "OBJECT" displayed.

How do I return the results of a clob.

Thanks

Kev
0
Comment
Question by:kb77
2 Comments
 

Accepted Solution

by:
geomon earned 300 total points
ID: 8652336
Personally, I find OCI support in PHP to be a pain in the rear.  I highly recommend using ADODB, a database abstraction layer.  I am using it on a project right now and it's pulling CLOBs just like any other char field from 9i like a champ.  Inserts and Updates are still tricky, but hey whatcha gonna do.

You can get it here --> http://php.weblogs.com/ADODB

George
0
 
LVL 33

Expert Comment

by:snoyes_jw
ID: 9682862
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation in the Cleanup topic area:

Answered by geomon

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

snoyes_jw
EE Cleanup Volunteer
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to create an extensible mechanism for linked drop downs.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question