December 2002
Intermediate to advanced
745 pages
17h 26m
English
book
Oracle® Web Application Programming for PL/SQL® Developers
by Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig
Content preview from Oracle® Web Application Programming for PL/SQL® Developers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...