#28 UT_FILEREPORTER Package Incomplete

[Michael Houben]

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

[Paul Walker]

• 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]

Applied Markdown formatting to the description to improve readability

[Svyatoslav Chatchenko]

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);