Database Tutorial

Course Tutorial Site

Site Admin

Oracle and PHP

with 13 comments

This page demonstrates how to upload, store, and manage CLOBs (Character Large OBjects) and BLOBs (Binary Large OBjects). It provides some instructions that supplement Chapter 8 in my Oracle Database 11g PL/SQL Programming book.

Before you begin these steps, you should have already installed Zend Server Community Edition. If you haven’t done so, please click here for instructions.

If you find any problems, please let me know. I’ll be happy to fix them.

Written by michaelmclaughlin

September 28th, 2009 at 11:42 pm

Posted in

13 Responses to 'Oracle and PHP'

Subscribe to comments with RSS or TrackBack to 'Oracle and PHP'.

  1. Thanks for the troubleshooting section! This helped a lot!


    25 Feb 10 at 12:03 pm

  2. Is it just me or does the Zend Community edition not come with Zend Core? My installation did not include it; is there a link for it somewhere that I missed?

    Sam Johansen

    29 Mar 10 at 2:57 pm

  3. The “Zend Server Community Edition” looks really different from the pictures shown under “Configure the Zend Engine”

    We had to click Server setup and then Extensions to check to make sure the image settings were set.

    Clay Mullins

    29 Mar 10 at 9:35 pm

  4. Yes, unfortunately the Zend Community Server continues to evolve. They screen shots give you the general flow.


    29 Mar 10 at 9:45 pm

  5. That should have been removed. It is removed now.


    29 Mar 10 at 9:47 pm

  6. Agreed with Jared


    30 Mar 10 at 9:28 am

  7. The text is uploading fine, and the database query is returning the picture id, but the picture itself isn’t displaying in the browser with the text. It has a broken image icon.

    Dane Christiansen

    30 Mar 10 at 11:45 am

  8. Have you confirmed that the image is written to the database row that you’re querying?


    30 Mar 10 at 12:01 pm

  9. I am getting this error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

    I have tried all the troubleshooting steps above. No luck. Any Ideas?

    Kyle Redfearn

    31 Mar 11 at 1:40 pm

  10. Is your database started?


    2 May 11 at 10:57 am

  11. I got the same error that Kyle did last semester. The one which says: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. My database was started and I used the troubleshooting steps but they didn’t work. Then I realized that it might have been a problem with one of the zip files.

    I went into the file and realized that by default it is setup for those using the Oracle 11g Database and I am running the Oracle 10g Database. So I just changed the “define” end bit under the connection variables from …”localhost/orcl” to …”localhost/xe” and now everything works just fine!

    Victoria Cole

    7 Dec 11 at 1:04 pm

  12. I’m having the same issue that Kyle had. From what I’ve seen so far, it has something to do with not being able to use port 80. I had to change my server to use port 81 to even have the webpage appear. However, when you click upload file, it thinks for a really long time, and then the error listed above by Kyle appears. I tried to turn my firewall off and and change my server to use port 80, but the webpage won’t appear, so I know that its not my firewall causing the problem. Any suggestions Brother McLaughlin?

    Jonathan Kirkham

    31 Mar 12 at 2:27 pm

  13. Enter the URL like this: http://localhost:81/file_name.php


    5 May 12 at 12:19 am

Leave a Reply