4. Code Compilation

One package of PL/SQL code runs the Discussionweb – by default it is called discussionweb.  To compile this package we recommend using an Oracle application development tool other than SQL*Plus – TOAD for example (the Tool for Oracle Application Developers, of which a trial version is available for free at http://www.toadsoft.com).  This will prevent the & symbols located in the code as part of its operation being incorrectly interpreted as substitution variables by SQL*Plus. 

The file containing the package of code can be found by taking the following path: Discussionweb_v.2 à Code.

After compiling the code run a commit command to save the changes to the database.