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?
FROM wf_countries WHERE country_id = p_country_id; DBMS_OUTPUT.PUT_LINE('The country name is '||v_country_name||‘ and the capital city is '|| v_capitol); EXCEPTION WHEN NO_DATA_FOUND THENDBMS_OUTPUT.PUT_LINE(‘This country does not exist’); END; 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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture