1 Reply Latest reply: Mar 21, 2012 7:03 AM by Helios-GunesEROL RSS

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

    Toni Lazarin
      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