-
Book Overview & Buying
-
Table Of Contents
PHP Oracle Web Development: Data processing, Security, Caching, XML, Web Services, and Ajax
By :
Employing a view is definitely the best way to go when you need to store a single SQL query in the database, hiding query complexity from the application developer. However, in practice you may need to implement a stored program unit that encapsulates a set of SQL statements and control-of-flow statements, such as loops and conditional statements, grouped together and processed with a single call. In such situations, Oracle recommends using stored subprograms.
Stored subprograms can be thought of as building blocks to create high-performance, maintainable, and secure database-driven applications.
A stored subprogram is a named program unit stored inside a database, ready to be executed. It runs in the database server, can take parameters and return values, and can be called by many users.
Looking through the above definition, you may notice that it says nothing about the programming language in which a stored subprogram can be implemented...
Change the font size
Change margin width
Change background colour