Academyoraclecom b execute your procedure from an

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

academy.oracle.com
B. Execute your procedure from an anonymous block, using country_id 90. C. Re-execute the procedure from the anonymous block, this time using country_id 95. What happens?
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 D. Retrieve your procedure code from Saved SQL and modify it to trap the NO_DATA_FOUND exception in an exception handler. Execute the modified procedure using country_id 95 again. Now what happens?
3. In your own words, describe what a formal parameter is and what an actual parameter is. Also, name three variations for an actual parameter.
4. Procedure Exercise: A. Write a procedure that displays the number of countries in a given region whose highest elevations exceed a given value. The procedure should accept two formal parameters, one for a region_id and the other for an elevation value for comparison. Use DBMS_OUTPUT.PUT_LINE to display the results in a message. Save your procedure code.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture