OraFAQ Forum: Precompilers, OCI & OCCI » ODPI or OCCI for Oracle 9i

Home » Developer & Programmer » Precompilers, OCI & OCCI » ODPI or OCCI for Oracle 9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ODPI or OCCI for Oracle 9i [message #670316]

Wed, 27 June 2018 08:18

sanjib2018
Messages: 4
Registered: June 2018

Junior Member

Hi All,

I am new Oracle. Currently planning to use ODPI-C to build one driver which would extract data from Oracle database version 9i release 1.
So is it possible to use ODPI-C Or shall we go for OCCI ? Please suggest

Report message to a moderator

Re: ODPI or OCCI for Oracle 9i [message #670317 is a reply to message #670316]

Wed, 27 June 2018 08:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sanjib2018 wrote on Wed, 27 June 2018 06:18

Hi All,

I am new Oracle. Currently planning to use ODPI-C to build one driver which would extract data from Oracle database version 9i release 1.
So is it possible to use ODPI-C Or shall we go for OCCI ? Please suggest

You should use what ever you can make work for you

Report message to a moderator

Re: ODPI or OCCI for Oracle 9i [message #670344 is a reply to message #670316]

Thu, 28 June 2018 06:23

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

sanjib2018 wrote on Wed, 27 June 2018 08:18

Hi All,

I am new Oracle. Currently planning to use ODPI-C to build one driver which would extract data from Oracle database version 9i release 1.
So is it possible to use ODPI-C Or shall we go for OCCI ? Please suggest

Use whatever you can get to work against that old, obsolete, out of support version of Oracle. It is so old it no longer shows up on Oracle's 'lifecycle schedule', which which doesn't even reference anything older than 10.1.0.5

Report message to a moderator

Re: ODPI or OCCI for Oracle 9i [message #670346 is a reply to message #670344]

Thu, 28 June 2018 06:39

sanjib2018
Messages: 4
Registered: June 2018

Junior Member

Thanks Stevens for your suggestion.

One more query i have like
As from document "ODPI-C can use Oracle Client 11.2, 12.1 or 12.2 libraries." , So Will it be a problem if i installed client 11.2 in my app server to access the lower version Oracle ( i.e 10g)?

Report message to a moderator

Re: ODPI or OCCI for Oracle 9i [message #670352 is a reply to message #670346]

Thu, 28 June 2018 08:15

Michel Cadot
Messages: 68511
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

8i and 10g is not the same thing.
What is your actual target version?

Report message to a moderator

Re: ODPI or OCCI for Oracle 9i [message #670356 is a reply to message #670352]

Thu, 28 June 2018 09:08

sanjib2018
Messages: 4
Registered: June 2018

Junior Member

Oracle Database version is 10g

Report message to a moderator

Re: ODPI or OCCI for Oracle 9i [message #670377 is a reply to message #670356]

Fri, 29 June 2018 08:34

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

sanjib2018 wrote on Thu, 28 June 2018 09:08

Oracle Database version is 10g

In your opening post you said "extract data from Oracle database version 9i"

So which is it? 9i or 10g?

BTW, '9i', '10g', etc. are marketing labels that only identify the db at a high level. In these forums we work with issues (like yours) that are sensitive to intermediate release levels. You need to get in the habit of knowing and referring to your databases by their 'decimal' designation -- 10.2.0.1, 11.2.0.4, 12.1.0.2, etc.

Report message to a moderator

Re: ODPI or OCCI for Oracle 9i [message #670378 is a reply to message #670346]

Fri, 29 June 2018 08:38

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

sanjib2018 wrote on Thu, 28 June 2018 06:39

Thanks Stevens for your suggestion.

One more query i have like
As from document "ODPI-C can use Oracle Client 11.2, 12.1 or 12.2 libraries." , So Will it be a problem if i installed client 11.2 in my app server to access the lower version Oracle ( i.e 10g)?

That could be problematic. You need to consult the client/server compatibility matrix on My Oracle Support .. Doc ID 207303.1

Report message to a moderator

Previous Topic:	PLS-S-00201, identifier 'STATS_MODE' must be declared
Next Topic:	OCI functions to load data in application directory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 11:00:25 CDT 2023