Oracle® Web Application Programming for PL/SQL® Developers

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 ...