Q29
Single choice
Examine the following error:
SQL> DECLARE
v_runid NUMBER;
BEGIN
v_runid := DBMS_HPROF.ANALYZE (LOCATION => 'PROFILE_DATA',
FILENAME => 'pd_cc_pkg.txt');
DBMS_OUTPUT.PUT_LINE('Run ID: ' || v_runid);
END;
DECLARE
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_HPROF", line 299
ORA-06512: at line 4
What would you do to execute the above block successfully?