Ways to connect without installing oracle client?

[SaKa]

Hi Guys,
Just wondering if its possible to connect PLSQLD to Oracle database without having to install Oracle Client please?

The SQLDeveloper(Oracle free GUI) connects to oracle without oracle client so wondering if a similar thing is in latest PLSQLD as well.

Thanks in advance.
Sak

 

[Marco Kalter]

PL/SQL Developer requires an Oracle Client. This can either be an Oracle Instant Client, or a fully installed Oracle Client.

 

[sakalk]

Hi Marco,
Is there no plans to enhance to include such a thing or bundle instant client install as a optional install within PLSQLD install or something or any other method like use of jdbc drivers?

Thanks
Sak

 

[Marco Kalter]

We currently do not have any plans for this at the moment.

Note that you can already copy the instant client directory into an "InstantClient" subdirectory in the PL/SQL Developer installation directory. You can place the tnsnames.ora file and sqlnet.ora files in a "Network" subdirectory in the "InstantClient" subdirectory. PL/SQL Developer will automatically pick up this client configuration. You only need to define an NLS_LANG in this case.

 

[sakalk]

Hi marco,
I am interested in knowing more about this, are you saying that on a PC where oracle was never installed, we can copy this "InstantClient"(Is this from nother install?) to PLSQLD folders and it will work without any additional installs?

Thanks
Sak

 

[fabrice]

Yes, or you can download instant client from oracle.
Don't forget tnsnames.ora and sqlnet.ora.