pdfcoffee.com_plsql-8-3-practice-pdf-free.pdf -...

Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/respective owners. or its affiliates. Other names may be trademarks of their
JESUS EMANUEL GALVAN DIAZ 1630353
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
y

2
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 © 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/respective owners. or its affiliates. Other names may be trademarks of their
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.