This discussion is archived
1 Reply Latest reply: Mar 21, 2012 5:03 AM by Helios-GunesEROL RSS

Advanced Application Developer's Guide 11g Release 2 ,Part Number E25518-04

Toni Lazarin Expert
Currently Being Moderated
Hi,

*8 Using the PL/SQL Hierarchical Profiler*
Example 8-2 Invoking DBMS_HPROF.analyze
1 DECLARE
2   runid NUMBER;
3 BEGIN
4   runid := DBMS_HPROF.analyze(LOCATION=>'PLSHPROF_DIR',
5                               FILENAME=>'test.trc');
6   DBMS_OUTPUT.PUT_LINE('runid = ' || runid)
7 END;
8 /
@line 6,
a semicolon(;) punctuation mark is missing at the end of the line.
http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_profiler.htm#CHDDDIHF

Regards,
Toni

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points