PLSQL_8_3.docx - Database Programming with PL/SQL 8-3...

  • No School
  • AA 1
  • jpcordero94
  • 6
  • 100% (4) 4 out of 4 people found this document helpful

This preview shows page 1 - 3 out of 6 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 Notation 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 Notation Lists some of the actual parameters as positional (no special operator) and some as named (with the => operator) Positional Notation 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?
Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. 2 Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture