ch05 - P L / S Q L Oracle10g Developer: PL/SQL Programming...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
P L / S Q L Oracle10 g Developer: PL/SQL Programming Chapter 5 Procedures
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Oracle10g Developer: PL/SQL Programming 2 Chapter Objectives After completing this lesson, you should be able to understand: Named program units How to identify parameters The CREATE PROCEDURE statement Creating a procedure in SQL*Plus Using the IN OUT parameter Calling procedures from other blocks Using the DESCRIBE command with procedures
Background image of page 2
P L / S Q L Oracle10g Developer: PL/SQL Programming 3 Chapter Objectives (continued) After completing this lesson, you should be able to understand (continued): Debugging procedures using DBMS_OUTPUT Identifying useful software utilities for PL/SQL Using subprograms The scope of exception handling and transactions Using RAISE_APPLICATION_ERROR for error handling Removing procedures
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Rebuild database Load and run “c5Dbcreate.sql” Oracle10g Developer: PL/SQL Programming 4
Background image of page 4
P L / S Q L What we had before PL/SQL blocks executed thus far have been anonymous blocks Anonymous blocks The code was not stored for reuse The block of code no longer exists after it has executed Oracle10g Developer: PL/SQL Programming 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Oracle10g Developer: PL/SQL Programming 6 Named Program Units Now we will assign a name to the block and save it in the database as a stored program unit This makes program units reusable
Background image of page 6
P L / S Q L Named Program Units A PL/SQL block created and named is known as a named program unit or subprogram The term program unit is used to denote that we typically create blocks of code to perform a specific task that may be needed within a number of applications Here, we focus primarily on stored program units , which denote that the program unit has been saved in database. Anyone connected to the database can use or call a stored program unit. Oracle10g Developer: PL/SQL Programming 7
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Named Program Units As application programmers, one critical task to accomplish is creating code that is easy to maintain. PL/SQL program units are critical as a mechanism in providing application code modularization and reusability. Oracle10g Developer: PL/SQL Programming 8
Background image of page 8
P L / S Q L Client and server considerations Reminding Client-side refers to program code that resides on the user or client machine Server-side refers to program code that reside on the server. PL/SQL program unit coding is the same regardless of whether it is stored on the database server or saved on local library on the user’s computer. Oracle10g Developer: PL/SQL Programming 9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
P L / S Q L Client and server considerations The concern in the application development arena involves the decision as to which part of the application code should be stored in the client, or the front end, and which part of the application code should be stored on the server. Typically, any PL/SQL block that has the potential
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/17/2012 for the course GCIS 511 taught by Professor Liu during the Fall '10 term at Gannon.

Page1 / 55

ch05 - P L / S Q L Oracle10g Developer: PL/SQL Programming...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online