Re: PHP and PL/SQL(oracle)
| From: | Philippe Saladin | Date: | Tue, 15 Apr 2003 06:47:08 +0000 |
| Subject: | Re: PHP and PL/SQL(oracle) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-143872@lists.php.net to get a copy of this message | ||
"Jason Paschal" <j_paschal@hotmail.com> a écrit dans le message news:
F65TK1Fj4seHoEjAQUc0001998d@hotmail.com...
> a friend of mine is an oracle programmer(PL/SQL). he asked me if php has
> oracle connectivity, which it does, but also wants to know if he'll be
able
> to work with stored procedures. i've googled for info regarding these two
> flavors and searched the php site. the oracle functions on php.net do not
> mention much about procedures and what i've found is not very in-depth.
be sure to look at the oci8 functions and not the ora_* functions.
The first one is the oldest way to connect to oracle, the second uses the
Oracle8 Call-Interface to communicate with both oracle 7 and oracle 8 (and 9
?). This one is needed to use stored procedures. See the example at
http://www.php.net/manual/en/ref.oci8.php
> part of the problem is that i'm not sure of the questions to ask, since
i'm
> accustomed to working with mysql and php, two great tastes that taste
great
> together.
> if anyone is aware of any online or offline resources that cover
php/oracle
> unions, i'd be very appreciative if they would share their knowledge with
> me.
simple tutorial : http://www.thickbook.com/extra/php_oracle.phtml
phporacleadmin : http://phporacleadmin.org/
efficient use of oracle8i and php :
http://conf.php.net/pres/slides/oci/paper.txt
configuring php with oracle support :
http://www.enderunix.org/documents/eng/php_oracle_en.html
an other one : http://dehaese.free.fr/
> thank you,
> jason paschal
>
Hope it will help you
Philippe