B execute your procedure from an anonymous block

This preview shows page 2 - 4 out of 5 pages.

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?
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.
A formal parameter is the parameter in the header of a procedure that gives the parameter a name and datatype. An actual parameter is the value passed from the calling environment when the procedure is executed. The formal parameter name is referenced within the procedure code. Actual parameter can be expressions, literal values, or variables.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture