O'Reilly logo

Oracle APEX Best Practices by Learco Brizzi, Iloon Ellen-Wolff, Alex Nuijten

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Deploying the database packages

When you keep all your files in folders, it is very convenient to generate a script with all the filenames in a single SQL file to be installed. That way, you will always know which files to call to install the database objects.

To generate the file to install the package specifications, we use a BAT file, which looks similar to the following. We have similar files for the other database objects.

@ECHO OFF REM =================================== REM == Prepare the Command Processor == REM =================================== SETLOCAL ENABLEEXTENSIONS SETLOCAL ENABLEDELAYEDEXPANSION SETLOCAL SET outputfile=%0 SET outputfile=%outputfile:~0,-4%.sql set workdir=%~dp0 set currdir=%cd% cd %workdir% ECHO ------------------------------------------- ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required