Re: [PHP-DEV] Oracle 8.1.7
Does anyone have an access to any lower versions of Oracle Servers and Oracle Clients to compile and test from CVS? Especially Client. If so, please let me know. I've got access to Oracle 8.0.5 on Linux. Edin -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Oracle 8.1.7
Can't you just check if it exists and add some #ifdef's in the code? --Jani On Mon, 25 Nov 2002, Maxim Maletsky wrote: Guys, I'm hassling on a quite mysterious and not documented (but pretty useful) function for OCI8 called OCIServerRelease() which would return you the Oracle Server release integer for compatibility comparisons. Because there are no official docs anywhere about this function (WTF? google only returns 2 pages both of which is Ruby's OCI8 module docs), I was unable to track it's BC, although tests for me worked just fine. So, what I am trying to do instead is to test this OCI call on lower Oracle versions. So far it worked smoothly for me on three Oracle machines I currently have access to: * Oracle9i Release 9.0.2.0.1 * Oracle9i Release 9.0.1.1.1 * Oracle8i Enterprise Edition Release 8.1.7.3.0 Both with Client 9. Does anyone have an access to any lower versions of Oracle Servers and Oracle Clients to compile and test from CVS? Especially Client. If so, please let me know. Cheers, -- Maxim Maletsky [EMAIL PROTECTED] -- - For Sale! - -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Oracle 8.1.7
Perhaps, but not all is that easy - OCI uses its own definitions for every function, and so far I have not found what defined this one. Also because there is no documentation about this call whatsoever, I am a little lost understanding it well - I only see how it is used with several libraries. --- Maxim Maletsky [EMAIL PROTECTED] On Tue, 26 Nov 2002 01:09:13 +0200 (EET) Jani Taskinen [EMAIL PROTECTED] wrote: Can't you just check if it exists and add some #ifdef's in the code? --Jani On Mon, 25 Nov 2002, Maxim Maletsky wrote: Guys, I'm hassling on a quite mysterious and not documented (but pretty useful) function for OCI8 called OCIServerRelease() which would return you the Oracle Server release integer for compatibility comparisons. Because there are no official docs anywhere about this function (WTF? google only returns 2 pages both of which is Ruby's OCI8 module docs), I was unable to track it's BC, although tests for me worked just fine. So, what I am trying to do instead is to test this OCI call on lower Oracle versions. So far it worked smoothly for me on three Oracle machines I currently have access to: * Oracle9i Release 9.0.2.0.1 * Oracle9i Release 9.0.1.1.1 * Oracle8i Enterprise Edition Release 8.1.7.3.0 Both with Client 9. Does anyone have an access to any lower versions of Oracle Servers and Oracle Clients to compile and test from CVS? Especially Client. If so, please let me know. Cheers, -- Maxim Maletsky [EMAIL PROTECTED] -- - For Sale! - -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Oracle 8.1.7
That sounds very good. What version is your oracle client? --- Maxim Maletsky [EMAIL PROTECTED] On Tue, 26 Nov 2002 00:03:36 +0100 Edin Kadribasic [EMAIL PROTECTED] wrote: Does anyone have an access to any lower versions of Oracle Servers and Oracle Clients to compile and test from CVS? Especially Client. If so, please let me know. I've got access to Oracle 8.0.5 on Linux. Edin -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Oracle 8.1.7
That sounds very good. What version is your oracle client? The client is on the same Linux box, so the version is still 8.0.5. Edin -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Oracle 8.1.7
ok. here is the patch as txt. It applies to the latest CVS of the file. But, in any case - there is only that very function that is not documented anywhere, and I wonder whether it works. to test it, just run this: ?php $conn = OCILogon('user', 'pass', 'listener'); echo \nServer version: . OCIServerVersion($conn); echo \nServer release: . OCIServerRelease($conn); /* you should expect something like that. Important part is the last line - release code Server version: Oracle9i Enterprise Edition Release 9.0.1.1.0 - Production With the Partitioning option JServer Release 9.0.1.0.0 - Production Server release: 150999296 */ ? let me know. --- Maxim Maletsky [EMAIL PROTECTED] On Tue, 26 Nov 2002 00:18:17 +0100 Edin Kadribasic [EMAIL PROTECTED] wrote: That sounds very good. What version is your oracle client? The client is on the same Linux box, so the version is still 8.0.5. Edin -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Oracle 8.1.7
No go. OCIServerRelease seems not to be supported in Oracle 8.0: ext/oci8/oci8.o: In function `zif_ociserverrelease': ext/oci8/oci8.c:4551: undefined reference to `OCIServerRelease' Edin - Original Message - From: Maxim Maletsky [EMAIL PROTECTED] To: Edin Kadribasic [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 12:46 AM Subject: Re: [PHP-DEV] Oracle 8.1.7 ok. here is the patch as txt. It applies to the latest CVS of the file. But, in any case - there is only that very function that is not documented anywhere, and I wonder whether it works. to test it, just run this: ?php $conn = OCILogon('user', 'pass', 'listener'); echo \nServer version: . OCIServerVersion($conn); echo \nServer release: . OCIServerRelease($conn); /* you should expect something like that. Important part is the last line - release code Server version: Oracle9i Enterprise Edition Release 9.0.1.1.0 - Production With the Partitioning option JServer Release 9.0.1.0.0 - Production Server release: 150999296 */ ? let me know. --- Maxim Maletsky [EMAIL PROTECTED] On Tue, 26 Nov 2002 00:18:17 +0100 Edin Kadribasic [EMAIL PROTECTED] wrote: That sounds very good. What version is your oracle client? The client is on the same Linux box, so the version is still 8.0.5. Edin -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DEV] Oracle 8.1.7
That's what I thought... Gonna have now to look for the definition of the function to avoid the compiling failure. Many thanks, man! --- Maxim Maletsky [EMAIL PROTECTED] On Tue, 26 Nov 2002 01:18:15 +0100 Edin Kadribasic [EMAIL PROTECTED] wrote: No go. OCIServerRelease seems not to be supported in Oracle 8.0: ext/oci8/oci8.o: In function `zif_ociserverrelease': ext/oci8/oci8.c:4551: undefined reference to `OCIServerRelease' Edin - Original Message - From: Maxim Maletsky [EMAIL PROTECTED] To: Edin Kadribasic [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 12:46 AM Subject: Re: [PHP-DEV] Oracle 8.1.7 ok. here is the patch as txt. It applies to the latest CVS of the file. But, in any case - there is only that very function that is not documented anywhere, and I wonder whether it works. to test it, just run this: ?php $conn = OCILogon('user', 'pass', 'listener'); echo \nServer version: . OCIServerVersion($conn); echo \nServer release: . OCIServerRelease($conn); /* you should expect something like that. Important part is the last line - release code Server version: Oracle9i Enterprise Edition Release 9.0.1.1.0 - Production With the Partitioning option JServer Release 9.0.1.0.0 - Production Server release: 150999296 */ ? let me know. --- Maxim Maletsky [EMAIL PROTECTED] On Tue, 26 Nov 2002 00:18:17 +0100 Edin Kadribasic [EMAIL PROTECTED] wrote: That sounds very good. What version is your oracle client? The client is on the same Linux box, so the version is still 8.0.5. Edin -- PHP Development Mailing List http://www.php.net/ To unsubscribe, visit: http://www.php.net/unsub.php