JPublisher Parameters

You can specify the user name used to log in to the database, the package name that is used to generate the PL/SQL wrapper, the name of the generated wrapper package, the filename of the generated PL/SQL wrapper, and the directory to save the PL/SQL wrapper file.

The following table lists the JPublisher parameters:

Parameter	Description
-user	Specifies the credentials used to log in to the database to extract the API information. Note: The logged-in user must have all privileges to the API packages and Oracle Database Dictionary tables. Therefore, it is good practice to use the apps user to avoid any privilege issues.
-url	Contains the JDBC connection string used to connect to the database. Typically, the format is `jdbc:oracle:thin:@[Database Server]:[Port]:[SID]`. For example, `jdbc:oracle:thin:@oracle-ebs-server:1521:VIS`.
-plsqlmap	Initializes Oracle JPublisher to generate the PL/SQL script wrapper. Its value is always. For example, `-plsqlmap=always`.
-sql	Specifies the package name in the Oracle database that is used to generate the PL/SQL wrapper.
-plsqlpackage	Specifies the name of the generated wrapper package. It is good practice to use TIB_ as the prefix for the API package name. For example, if `-sql=BOM_BO_PUB`, then `-plsqlpackage=TIB_BOM_BO_PUB`.
-plsqlfile	Specifies the filename of the generated PL/SQL wrapper. It is good practice to use the SQL package name or the PLS package name (for example, BOM_BO_PUB or TIB_BOM_BO_PUB) so that the filename can be used to identify the package referenced by the PL/SQL wrapper.
-dir	Specifies the directory to save the PL/SQL wrapper file.