RE: [PHP] Oracle 7 support
-Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 12:18 Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ? Yes. I have found functions specific to Oracle 8i and some more generic functions (are these only for Oracle 9?). No -- the OCI8 functions are actually recommended for Oracle 7 upwards. The ora_* functions are older and do not use the newer OCI methodology. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
Dan Field [EMAIL PROTECTED] wrote... : Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ? Yes, it is. Oracle extension is supporting Oracle 7th version, while OCI8 is primarily for 8 and 9th versions, they might be also working for Oracle 7. I have found functions specific to Oracle 8i and some more generic functions (are these only for Oracle 9?). Generic (ora_*) are for Oracle 7 and up, OCI8 is for 8 and 9. Also, is there a doc containing all levels of support for 3rd party products? save me pestering the list in future. I couldn't locate it myself though. Official manual has a list of PHP extension - that is what one should read. -- Maxim Maletsky [EMAIL PROTECTED] Many thanks, -- Dan Field Systems Development Officer - Social Services Dept. Ceredigion County Council. Mae'r neges ebost hon, ynghyd ag unrhyw ffeiliau sydd ynghlwm wrthi, yn gyfrinachol ac at ddefnydd yr unigolyn neu sefydliad y cyfeiriwyd hi ato. Pe dderbynioch y neges hon mewn camgymeriad, byddwch mor garedig a rhoi gwybod i'r rheolwr system. Mae'r nodyn hwn hefyd yn cadarnhau bod y neges ebost hon wedi cael ei archwilio am bresenoldeb feirws cyfrifiadurol gan MIMEsweeper. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
OCI 7 does not need any modification to support 8 and 9 but they aren't as powerful, thus should only be used for Oracle 7. OCI8 is the 8th OCI and fully supports Oracle 8 with and Oracle 9. For Oracle 9 there are a few thing that are missing, but overall can be safely used on high level production environments. We interface 3.5 Terrabytes Oracle 8 database framework for an e-government project using PHP's OCI8 extension. -- Maxim Maletsky [EMAIL PROTECTED] Ford, Mike [LSS] [EMAIL PROTECTED] wrote... : -Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 12:18 Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ? Yes. I have found functions specific to Oracle 8i and some more generic functions (are these only for Oracle 9?). No -- the OCI8 functions are actually recommended for Oracle 7 upwards. The ora_* functions are older and do not use the newer OCI methodology. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Oracle 7 support
On Tue, 2002-11-12 at 13:03, Ford, Mike [LSS] wrote: -Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 12:18 Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ? Yes. I have found functions specific to Oracle 8i and some more generic functions (are these only for Oracle 9?). No -- the OCI8 functions are actually recommended for Oracle 7 upwards. The ora_* functions are older and do not use the newer OCI methodology. That is great news, thanks Mike. My second problem then lies with my current PHP Setup. I have been using the binary RPMs from RedHat up to now, which do not sem to have been compiled with the Oracle functionality included. If I recompile PHP, will I need the Oracle headers on the machine also? If so this could be a problem as the Oracle server I wish to use is not on the same machine as the webserver. Cheers -- Dan Field Systems Development Officer - Social Services Dept. Ceredigion County Council. Mae'r neges ebost hon, ynghyd ag unrhyw ffeiliau sydd ynghlwm wrthi, yn gyfrinachol ac at ddefnydd yr unigolyn neu sefydliad y cyfeiriwyd hi ato. Pe dderbynioch y neges hon mewn camgymeriad, byddwch mor garedig a rhoi gwybod i'r rheolwr system. Mae'r nodyn hwn hefyd yn cadarnhau bod y neges ebost hon wedi cael ei archwilio am bresenoldeb feirws cyfrifiadurol gan MIMEsweeper. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Oracle 7 support
-Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 13:39 On Tue, 2002-11-12 at 13:03, Ford, Mike [LSS] wrote: -Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 12:18 Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ? Yes. I have found functions specific to Oracle 8i and some more generic functions (are these only for Oracle 9?). No -- the OCI8 functions are actually recommended for Oracle 7 upwards. The ora_* functions are older and do not use the newer OCI methodology. That is great news, thanks Mike. My second problem then lies with my current PHP Setup. I have been using the binary RPMs from RedHat up to now, which do not sem to have been compiled with the Oracle functionality included. If I recompile PHP, will I need the Oracle headers on the machine also? If so this could be a problem as the Oracle server I wish to use is not on the same machine as the webserver. Sorry, I can't help with this one as I'm not the administrator of our main Unix server, and my test server is Windows so I used the pre-compiled binaries. But hopefully one of the Oracle gurus on this list will spring to your aid! Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
Hello, First, let me just say that I'm no Oracle guru. :) But while we're waiting for them... Ford, Mike [LSS] [EMAIL PROTECTED] wrote: -Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 13:39 ...[snip]... That is great news, thanks Mike. My second problem then lies with my current PHP Setup. I have been using the binary RPMs from RedHat up to now, which do not sem to have been compiled with the Oracle functionality included. If I recompile PHP, will I need the Oracle headers on the machine also? If so this could be a problem as the Oracle server I wish to use is not on the same machine as the webserver. Sorry, I can't help with this one as I'm not the administrator of our main Unix server, and my test server is Windows so I used the pre-compiled binaries. But hopefully one of the Oracle gurus on this list will spring to your aid! *I think* you need to have Oracle installed even if you wouldn't really connect to it but instead connect to a different server. Since I installed Oracle with most of the Linux installations that I did, I haven't really tried enabling Oracle support in PHP without Oracle on the same server. In other words, I haven't really tried configuring --with-oci8 without supplying the path (e.g. --with-oci8=/path/to/oracle/ ). PHP will look for the needed file when configuring so I don't think you can really get away without installing Oracle first. (Of course, you can just try to find out what files are needed, ask a friend to give you a copy, trick php that it exists, etc.--it might not work though...) Anyway, if you need Oracle, try the OTN site. There's one that you can use for development. - E -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
Your machine will need the Oracle headers which are included in Oracle Client. So, in two words - your machine needs Oracle client installed. Try doing: echo $ORACLE_HOME in your command prompt -- Maxim Maletsky [EMAIL PROTECTED] Dan Field [EMAIL PROTECTED] wrote... : On Tue, 2002-11-12 at 13:03, Ford, Mike [LSS] wrote: -Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 12:18 Can anyone tell me if Oracle 7 is supported by PHP 4.2.2 ? Yes. I have found functions specific to Oracle 8i and some more generic functions (are these only for Oracle 9?). No -- the OCI8 functions are actually recommended for Oracle 7 upwards. The ora_* functions are older and do not use the newer OCI methodology. That is great news, thanks Mike. My second problem then lies with my current PHP Setup. I have been using the binary RPMs from RedHat up to now, which do not sem to have been compiled with the Oracle functionality included. If I recompile PHP, will I need the Oracle headers on the machine also? If so this could be a problem as the Oracle server I wish to use is not on the same machine as the webserver. Cheers -- Dan Field Systems Development Officer - Social Services Dept. Ceredigion County Council. Mae'r neges ebost hon, ynghyd ag unrhyw ffeiliau sydd ynghlwm wrthi, yn gyfrinachol ac at ddefnydd yr unigolyn neu sefydliad y cyfeiriwyd hi ato. Pe dderbynioch y neges hon mewn camgymeriad, byddwch mor garedig a rhoi gwybod i'r rheolwr system. Mae'r nodyn hwn hefyd yn cadarnhau bod y neges ebost hon wedi cael ei archwilio am bresenoldeb feirws cyfrifiadurol gan MIMEsweeper. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
Well, I will spread some light - I maintain OCI8 extension :) Your machine does not need Oracle Server installed, it needs Oracle Client installed. These are two completely different things. So, try this in your command prompt: echo $ORACLE_HOME if you get a result, means the client is there and you can recompile php --with-oci8=$ORACLE_HOME That will compile the OCI8 extension with all the required headers. Cheers, -- Maxim Maletsky [EMAIL PROTECTED] @ Edwin [EMAIL PROTECTED] wrote... : Hello, First, let me just say that I'm no Oracle guru. :) But while we're waiting for them... Ford, Mike [LSS] [EMAIL PROTECTED] wrote: -Original Message- From: Dan Field [mailto:danf;ceredigion.gov.uk] Sent: 12 November 2002 13:39 ...[snip]... That is great news, thanks Mike. My second problem then lies with my current PHP Setup. I have been using the binary RPMs from RedHat up to now, which do not sem to have been compiled with the Oracle functionality included. If I recompile PHP, will I need the Oracle headers on the machine also? If so this could be a problem as the Oracle server I wish to use is not on the same machine as the webserver. Sorry, I can't help with this one as I'm not the administrator of our main Unix server, and my test server is Windows so I used the pre-compiled binaries. But hopefully one of the Oracle gurus on this list will spring to your aid! *I think* you need to have Oracle installed even if you wouldn't really connect to it but instead connect to a different server. Since I installed Oracle with most of the Linux installations that I did, I haven't really tried enabling Oracle support in PHP without Oracle on the same server. In other words, I haven't really tried configuring --with-oci8 without supplying the path (e.g. --with-oci8=/path/to/oracle/ ). PHP will look for the needed file when configuring so I don't think you can really get away without installing Oracle first. (Of course, you can just try to find out what files are needed, ask a friend to give you a copy, trick php that it exists, etc.--it might not work though...) Anyway, if you need Oracle, try the OTN site. There's one that you can use for development. - E -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
Dan Field wrote: functionality included. If I recompile PHP, will I need the Oracle headers on the machine also? If so this could be a problem as the Oracle server I wish to use is not on the same machine as the webserver. Seems lots of us have not actually tried doing it without Oracle installed! To connect to a database you will need the networking code and specifically the tnsnames.ora file. Check for this. I think it unlikely to come with php since it is proprietry code. Its only the Oracle client installation you would need (not server) and only the networking code. HTH Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
Maxim Maletsky [EMAIL PROTECTED] wrote: Well, I will spread some light - I maintain OCI8 extension :) Your machine does not need Oracle Server installed, it needs Oracle Client installed. These are two completely different things. So, try this in your command prompt: echo $ORACLE_HOME if you get a result, means the client is there and you can recompile php --with-oci8=$ORACLE_HOME That will compile the OCI8 extension with all the required headers. Now, that make sense :) Thanks! - E -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Oracle 7 support
First, let me just say that I'm no Oracle guru. :) But while we're waiting for them... Thanks, all help appreciated :) *I think* you need to have Oracle installed even if you wouldn't really connect to it but instead connect to a different server. Since I installed Oracle with most of the Linux installations that I did, I haven't really tried enabling Oracle support in PHP without Oracle on the same server. In other words, I haven't really tried configuring --with-oci8 without supplying the path (e.g. --with-oci8=/path/to/oracle/ ). It certainly looks that way. PHP will look for the needed file when configuring so I don't think you can really get away without installing Oracle first. (Of course, you can just try to find out what files are needed, ask a friend to give you a copy, trick php that it exists, etc.--it might not work though...) Yes this is right too. I greabed the SRC RPM for PHP 4.2.2 and edited the spec file to include --with-oci8 but it now throws the following errors: checking for Oracle-OCI8 support... yes, shared checking Oracle Install-Dir... checking Oracle version... configure: error: Oracle-OCI8 needed libraries not found error: Bad exit status from /var/tmp/rpm-tmp.47391 (%build) Anyway, if you need Oracle, try the OTN site. There's one that you can use for development. Luckally I had downloaded the Oracle-Linux (Version 8i) installer a few weeks ago incase this problem arised. but the installer is currently taking 98% of my CPU with the Java Runtime and it doesn't seem to be doing a lot else (not even a GUI window yet . 20 minutes later). I fear this is too OT for the list though. If anyone does know if I can trick PHP by just copying some files from the Oracle-Linux.tar then this would be a great help though. Thanks all for your support. -- Dan Field Systems Development Officer - Social Services Dept. Ceredigion County Council. Mae'r neges ebost hon, ynghyd ag unrhyw ffeiliau sydd ynghlwm wrthi, yn gyfrinachol ac at ddefnydd yr unigolyn neu sefydliad y cyfeiriwyd hi ato. Pe dderbynioch y neges hon mewn camgymeriad, byddwch mor garedig a rhoi gwybod i'r rheolwr system. Mae'r nodyn hwn hefyd yn cadarnhau bod y neges ebost hon wedi cael ei archwilio am bresenoldeb feirws cyfrifiadurol gan MIMEsweeper. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
