DBI AND ORACLE 8

BillB has asked for the wisdom of the Perl Monks concerning the following question:

This is my problem. I am using the ACTIVESTATE perl version 5.26.1 fully updated. I have the oracle 8i client, 10g, and 12c clients all installed on my workstation. When I use DBI to connect to an 8i production database it is failing with an ORA-03134 error (version too old). The 10g client can connect to my 8i, 9i, and 10g database with no problems. I can't figure out how to generate the DBI module to use it with the 10g client. Any help would be appreciated

Comment on DBI AND ORACLE 8

Replies are listed 'Best First'.
Re: DBI AND ORACLE 8 by marto (Cardinal) on Nov 02, 2018 at 12:45 UTC
Which version of DBD::Oracle is for me. You've built against one specific oracle client, not multiple.	[reply]
Re^2: DBI AND ORACLE 8 by BillB (Acolyte) on Nov 02, 2018 at 13:00 UTC
Thanks for the reply. The compile of DBI used the most current client 12c. I want to make it recompile to use the 10g client so I can access my obsolete databases until we can get them upgraded to Oracle 18	[reply]
Re^3: DBI AND ORACLE 8 by marto (Cardinal) on Nov 02, 2018 at 13:44 UTC
If you're asking how to do this, set the `ORACLE_HOME` environment variable to to path of the client you wish to build against, then do a manual build: `perl Makefile.PL gmake gmake test gmake install` [download] Substitute gmake for the appropriate version for your perl distribution. If you care about the tests consider altering the `ORACLE_USERID` to an appropriate username/password@database string.	[reply] [d/l] [select]
Re^4: DBI AND ORACLE 8 by BillB (Acolyte) on Nov 02, 2018 at 15:01 UTC