CODEWITHSUNDEEP
oracle-database
user1831003
user1831003

Reputation: 194

oracle instant client and ORACLE_HOME environment variable

I have Oracle Server and Oracle Instant Client on the same machine. (Windows 7)

Notes on Instant Client state that get rid of ORACLE_HOME environment variable.

I am using SQL Developer - If I want to install packages, I do not want to hardcode the path, but do something like Oracle_Home/..... (which I don't know the proper syntax of, btw)

How would I achieve this with ORACLE_HOME environment variable gone?

What is the proper syntax?

Upvotes: 0

Views: 5199

Answers (2)

Rene
Rene

Reputation: 10541

Oracle_home points to the location of where Oracle software is installed. It is needed for Oracle software to run correctly. It has nothing to do with the location of any package you want to install.

To install a package (I assume you are talking about an Oracle PL/SQL package) you can do this from SQLplus.

Open sqlplus and connect to the schema you want the package to reside in.

From the SQL plus command prompt type:

SQL>@<path to your package>\<package>

This will load the package into your schema.

Alternatively you can open the package in SQLDeveloper. Make a connection to the schema and compile it.

Upvotes: 0

diederikh
diederikh

Reputation: 25281

SQL Developer just connects to the database port. It doesn't have to know about the ORACLE_HOME.

Upvotes: 0

Related Questions