Just finished a PHP contract which required the use of Oracle and that was a first for me. They also did not allow the use of the PDO Oracle extention so I had to write my own DB class. It was an interesting learning experience and I am quite proud of the results but realise that things can always be improved. So I invite any comments and suggestions that anyone may have. Feel free to adopt the code for your own needs if you want to.

I have added the code as an attachment because it is too long to include in a code post 😉

OracleDB.class.php.txt
    Roger Ramjet;11026425 wrote:

    ...They also did not allow the use of the PDO Oracle extention so I had to write my own DB class....

    Out of curiosity, why was PDO not allowed -- some good technical reason, or just obstinacy? 🙂

      Intranet hosting at a bank and that was the configuration they had. My guess is that it was because Oracle PDO is still listed as Experimental. Why Oracle themselves don't take over development and support of it is beyond me, especially as they have taken over Mysql and Sun and a whole load of open source products associated with them.

        Roger Ramjet;11026449 wrote:

        Intranet hosting at a bank and that was the configuration they had. My guess is that it was because Oracle PDO is still listed as Experimental. Why Oracle themselves don't take over development and support of it is beyond me, especially as they have taken over Mysql and Sun and a whole load of open source products associated with them.

        That's a good question; of course, in this case, they got their customer to pay a 3rd party to handle it for them ... at no cost to themselves. Oracle's not that altruistic, right? 😉

          Write a Reply...