PLSQL_8_3_Practice.docx - www.oracle.com/academy Database...

This preview shows page 1 - 3 out of 7 pages.

Database Programming with PL/SQL 8-3: Passing Parameters Practice Activities Vocabulary Identify the vocabulary word for each definition below: OUT parameter Returns a value to the caller In parameter Provides values for a subprogram to process Named Lists the actual parameters in arbitrary order and uses the association operator ( ‘=>' which is an equal and an arrow together) to associate a named formal parameter with its actual parameter Combination Lists some of the actual parameters as positional (no special operator) and some as named (with the => operator) Positional Lists the actual parameters in the same order as the formal parameters IN OUT PARAMETER Supplies an input value, which may be returned as a modified value Try It / Solve It 1. Name the three modes for parameters and indicate which mode is the default mode. Which mode cannot be modified inside the procedure?
2 2. Procedures: A. Create a procedure that receives a country_id as an IN parameter and returns the name and population of that country as OUT parameters. Include an exception handler to trap the NO_DATA_FOUND exception if the country does not exist. The procedure should not display the returned values; this will be done in the next step. Name your procedure find_area_pop. Save your code.
B.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture