Explaining PL/SQL Stored Procedures
PL/SQL stored procedures are program units that reside inside the database in text form. You use SQL Data Definition Language (DDL) to create stored procedures. The creation process compiles the code by running it through a PL/SQL parser to check for syntax errors and validate the existence of dependent database objects, like tables, views, packages, procedures, and functions. Stored procedures come in two varieties, stand-alone procedures and procedures inside of packages.
Stand-alone procedures are self-contained programs, having both a definition and an implementation. As described in Appendix I, PL/SQL is a strongly typed language. Procedure definitions qualify the formal parameter list by both position ...
Get Oracle Database 10g Express Edition PHP Web Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
