Oracle8i SQLJ Developer's Guide and Reference Release 8.1.5 A64684-01 |
|
Once you have verified that the above assumptions and requirements are satisfied, you must check your Oracle SQLJ installation.
Verify that the following directories have been installed and are populated.
If you are using one of the Oracle JDBC drivers, refer to the Oracle8i JDBC Developer's Guide and Reference for information about JDBC files that should be installed on your system.
Installing Oracle Java products will include, among other things, a sqlj
directory under your [Oracle Home]
directory, containing the following subdirectories:
demo
(demo applications, including some referenced in this chapter)
doc
lib
(.zip
files containing class files for SQLJ)
Also, directly under [Oracle Home]
is the following directory containing utilities for all Java product areas:
Check that all these directories have been created and populated, especially lib
and bin
.
Make sure your PATH
and CLASSPATH
environment variables have the necessary settings for Oracle SQLJ (and Oracle JDBC if applicable).
If you are using one of the Oracle JDBC drivers, refer to the Oracle8i JDBC Developer's Guide and Reference for information about required settings of the PATH
and CLASSPATH
environment variables for Oracle JDBC.
Set your PATH
and CLASSPATH
variables as follows.
To be able to run the sqlj
script (which invokes the SQLJ translator) without having to fully specify its path, verify that your PATH
environment variable has been updated to include the following:
[Oracle Home]/bin
Use backward-slashes for Windows. Replace [Oracle Home]
with your actual Oracle Home directory.
Update your CLASSPATH
environment variable to include the current directory as well as the following:
[Oracle Home]/sqlj/lib/translator.zip
Use backward-slashes for Windows. Replace [Oracle Home]
with your actual Oracle Home directory.
Note: This step is applicable only if you are using an Oracle database, and is not critical until you are at a point where you are using SQLJ stored procedures or functions. |
The package sqljutl
is required for online checking of stored procedures and functions in an Oracle database. It should have been installed automatically under the SYS
schema during installation of your database, unless you are using a previously existing database. To check the installation of sqljutl
, issue the following SQL command (from SQL*Plus
, for example):
describe package sqljutl
This should result in a brief description of the package. If you get a message indicating the package cannot be found, then you must install it manually. To do so, use SQL*Plus
to run the sqljutl.sql
script, which is located as follows:
[Oracle Home]/sqlj/lib/sqljutl.sql
Consult your installation instructions if necessary.