Running JPublisher

You can run JPublisher on a command line.

Open a command line window, and execute the following example command:

java oracle.jpub.Main -user=apps/apps -
url=jdbc:oracle:thin:@10.105.176.40:1521:VIS -sql=BOM_BO_PUB -
plsqlpackage=TIB_BOM_BO_PUB -plsqlmap=always -dir=java/BOM_BO_PUB -plsqlfile=sql/
BOM_BO_PUB/BOM_BO_PUB.sql

The execution might take some time (a few minutes for each PL/SQL wrapper) depending on the size of the API package specified and the database server resources available. During the execution, JPublisher lists the database types that have been wrapped.

JPublisher might attempt to compile the Java classes generated by running the Java compiler. This attempt might fail because -plsqlmap=always is selected. However, it does not affect the generation of the PL/SQL wrappers.

Result

When JPublisher executes the command successfully, two SQL scripts are generated, including a wrapper file and a file that is used to undo the wrapper changes. See JPublisher Wrapper Details for more details.