Oracle9i笔记1(3)

Invoking Stored Procedures and Functions

*Subprograms are named PL/SQL BLOCKS, declared as either procedures or functions. *You can invoke subprograms from different environments.

*Named PL/SQL blocks are also known as subprograms or program units. Procedures, functions, packages, and triggers are different PL/SQL constructs. You can invoke subprograms from different environments.

Chapter 1

Declaring Variables

After completing this lesson, you should be able to do the following: Recongnize the basic PL/SQL block and its sections Describe the significance of variables in PL/SQL Declare PL/SQL variables Execute a PL/SQL block

一、 Section: 1. Declarative

Contains all variables, constants, cursors, and user defined exceptions that are referenced in the executable and declarative sections It’s optional. 2. Executable

Contains SQL statements to manipulate data in the database and PL/SQL statements to manipulate data in the block It’s mandatory。 3. exception handling

Specifies the actions to perform when errors and abnormal conditions arise in the executable section It’s optional.

There are three parameter modes, IN ,OUT , and IN OUT . Use the IN parameter to pass values to the subprogram being called. Use the OUT parameter to return values to the caller of a subprogram. And use the IN OUT parameter to pass initial values to the subprogram being called and to return updated values to the caller. We pass values into anonymous block via isql*PLUS substitution variables.

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新人文社科Oracle9i笔记1(3)全文阅读和word下载服务。