#28 UT_FILEREPORTER Package Incomplete

Open
nobody
None
2.2 beta 2
[Unknown]
Medium
[none]
2015-01-20
2005-05-19
Michael Houben
No

hi,

i found a problem with the utfilereporter package. it
seems to be incomplete. according to the documentation,
every reporter package should have following procedures:

PROCEDURE open;
PROCEDURE pl (str IN VARCHAR2);

PROCEDURE before_results(run_id IN utr_outcome.run_id%TYPE);
PROCEDURE show_failure;
PROCEDURE show_result;
PROCEDURE after_results(run_id IN utr_outcome.run_id%TYPE);

PROCEDURE before_errors(run_id IN utr_error.run_id%TYPE);
PROCEDURE show_error;
PROCEDURE after_errors(run_id IN utr_error.run_id%TYPE);

PROCEDURE close;

the utfilereporter has only following procedures:

PROCEDURE open;
PROCEDURE pl (str IN  VARCHAR2);
PROCEDURE close(bool_abort BOOLEAN := FALSE);

--Simpler versions to be used by other reporters
PROCEDURE open_file(dir VARCHAR2, filename VARCHAR2, filemode VARCHAR2 := 'A');
PROCEDURE close_file;

If i try to use the utfilereporter package, i get the
following error messages:

UTL_FILE error: invalid_filehandle
ORA-29282: invalid file ID
ORA-06550: line 1, column 22:
PLS-00302: component 'BEFORE_RESULTS' must be declared
ORA-06550: line 1, column 7:

Important is the "PLS-00302" Error. Here you can see
that the BEFORE_RESULTS procedure is missing in the
utfilereporter package.

Greets,

Michael

Discussion

  • Paul Walker
    Paul Walker
    2013-10-12

    • Status: open --> Open
    • Priority: 5 --> Medium
     
  • Paul Walker
    Paul Walker
    2013-10-12

    • Fixed in version: --> [none]
     
  • Paul Walker
    Paul Walker
    2013-10-22

    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -4,51 +4,45 @@
     seems to be incomplete. according to the documentation,
     every reporter package should have following procedures:
    
    -
    -PROCEDURE open;
    -PROCEDURE pl \(str IN VARCHAR2\);
    -
    -PROCEDURE before\_results\(run\_id IN       
    -utr\_outcome.run\_id%TYPE\);
    -PROCEDURE show\_failure;
    -PROCEDURE show\_result;
    -PROCEDURE after\_results\(run\_id IN
    -utr\_outcome.run\_id%TYPE\);
    -
    -PROCEDURE before\_errors\(run\_id IN
    -utr\_error.run\_id%TYPE\);
    -PROCEDURE show\_error;
    -PROCEDURE after\_errors\(run\_id IN
    -utr\_error.run\_id%TYPE\);   
    -
    -PROCEDURE close;
    +    :::SQL
    +    PROCEDURE open;
    +    PROCEDURE pl (str IN VARCHAR2);
    +    
    +    PROCEDURE before_results(run_id IN utr_outcome.run_id%TYPE);
    +    PROCEDURE show_failure;
    +    PROCEDURE show_result;
    +    PROCEDURE after_results(run_id IN utr_outcome.run_id%TYPE);
    +    
    +    PROCEDURE before_errors(run_id IN utr_error.run_id%TYPE);
    +    PROCEDURE show_error;
    +    PROCEDURE after_errors(run_id IN utr_error.run_id%TYPE);   
    +    
    +    PROCEDURE close;
    
     the utfilereporter has only following procedures:
    
    -
    -PROCEDURE open;
    -PROCEDURE pl \(str IN  VARCHAR2\);
    -PROCEDURE close\(bool\_abort BOOLEAN := FALSE\);
    -
    -\--Simpler versions to be used by other reporters
    -PROCEDURE open\_file\(dir VARCHAR2, filename VARCHAR2,
    -filemode VARCHAR2 := 'A'\);
    -PROCEDURE close\_file;
    +    :::SQL
    +    PROCEDURE open;
    +    PROCEDURE pl (str IN  VARCHAR2);
    +    PROCEDURE close(bool_abort BOOLEAN := FALSE);
    +    
    +    --Simpler versions to be used by other reporters
    +    PROCEDURE open_file(dir VARCHAR2, filename VARCHAR2, filemode VARCHAR2 := 'A');
    +    PROCEDURE close_file;
    
     If i try to use the utfilereporter package, i get the
     following error messages:
    
    +    UTL_FILE error: invalid_filehandle
    +    ORA-29282: invalid file ID
    +    ORA-06550: line 1, column 22:
    +    PLS-00302: component 'BEFORE_RESULTS' must be declared
    +    ORA-06550: line 1, column 7:
    
    -UTL\_FILE error: invalid\_filehandle
    -ORA-29282: invalid file ID
    -ORA-06550: line 1, column 22:
    -PLS-00302: component 'BEFORE\_RESULTS' must be declared
    -ORA-06550: line 1, column 7:
    -
    -Important is the "PLS-00302" Error. Here you can see
    -that the BEFORE\_RESULTS procedure is missing in the
    +Important is the "`PLS-00302`" Error. Here you can see
    +that the `BEFORE_RESULTS` procedure is missing in the
     utfilereporter package.
    
    • Seen in version: --> 2.2
    • Oracle version: --> 12
     
  • Paul Walker
    Paul Walker
    2013-10-22

    Applied Markdown formatting to the description to improve readability

     
  • Paul Walker
    Paul Walker
    2013-10-22

    • Seen in version: 2.2 --> 2.2 beta 2
    • Oracle version: 12 --> [Unknown]
     
  • Paul Walker
    Paul Walker
    2013-10-22

    • summary: utplsql-2.2-beta-2: utfilereporter package incomplete --> UT_FILEREPORTER Package Incomplete
     
  • Filereporter works fine for me.
    just tried to use it and everything is ok!
    It is because of utreport.call exception handler which call the same procedure (eg. before_results) but implemented by DEFAULT_REPORTER

    call(proc, param, params, force_reporter => DEFAULT_REPORTER);