Creating the PL/SQL Package on the Database Server Manually

  1. Navigate to the /build/ses/dbsrvr/oracle folder, and untar the MktgListImportPkg.tar file to that directory.

  2. Use the instructions in the Readme.txt file to manually create the PL/SQL package on the database server.

  3. When the package has been successfully created on the database, navigate to the folder with the untarred folder and look for the mktg_listimp_pkg_body.log and mktg_listimp_pkg_spec.log files. If the file contains errors (such as TNS entry not valid… and so on), rerun the executable.

    If the mktg_listimp_pkg_body.log file contains the "Warning: Package Body created with compilation errors" error message, check with your administrator.