Answer b d e question 59 exhibit missing the procedure

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: , D, E QUESTION 59: Exhibit: ***MISSING*** The procedure RAISE_SALARY is a program unit in the EMPLOYEES_TEST form. It calls the RAISE_SALARIES function, which is a stored program unit. You are running the EMPLOYEES_TEST form in debug mode and you are stepping through code (as shown in the exhibit). When you click Step Into, the display does not change. After you click Ste into several times, the value of EMPLOYEES.SALARY changes, but you are never able to see the RAISE_SALARIES function. What action could you take so that the stored RAISE_SALARIES function appears in the stack and in the PL/SQL Editor as you are stepping through its code? A. Right-click the highlighted procedure in the Stack panel and select View Stored Code from the popup menu. B. Issue the following statement in SQL *Plus after creating the RAISE_SALARIES function: ALTER SESSION SET PLSQL_DEBUG=TRUE; C. Issue the following statement in SQL *Plus after creating the RAISE_SALARIES function: ALTER FUNCTION RAISE_SALARIES COMPILE DEBUG; D. None. Alt...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online