Unit 12.3. Loading PSPs into the Database
Loading a PSP
The loadpsp utility is a standard utility provided with Oracle versions 8.1.6 and above. To load a PSP file into the database, you use the loadpsp utility from an operating system prompt. It reads in the PSP and translates it into a stored procedure using the attributes provided in the utility directive. Each PSP file corresponds to only one stored procedure in the database. PSP pages are compiled and loaded into the database in one step. An example of the syntax follows:
loadpsp -user username/password@service_name file.psp
And an example with values is:
loadpsp -user web_book/author@web_book_service hello_world.psp
In this example, the hello_world.psp file is loaded into the web_book ...