Two players wrote with a concern about a possible conflict between the stated minimum version of this quiz (10.2) and the parameter list in the calls to UTL_FILE.FCOPY. Here's one of the comments:
Both of the players indicated that they had ignored what they saw as a problem, and answered it "based on what I think the intention was."
Good move, players! Because in fact there is no difference between the parameter lists of FCOPY in 10.2 and 11.2. The only difference is in the documentation.
In the 10.2 doc, FCOPY is described as:
UTL_FILE.FCOPY ( location IN VARCHAR2, filename IN VARCHAR2, dest_dir IN VARCHAR2, dest_file IN VARCHAR2, start_line IN PLS_INTEGER DEFAULT 1, end_line IN PLS_INTEGER DEFAULT NULL);While in the 11.2 doc, FCOPY is documented as having the following parameter list:
UTL_FILE.FCOPY ( src_location IN VARCHAR2, src_filename IN VARCHAR2, dest_location IN VARCHAR2, dest_filename IN VARCHAR2, start_line IN BINARY_INTEGER DEFAULT 1, end_line IN BINARY_INTEGER DEFAULT NULL);But if you actually look at the UTL_FILE package specification in a 10.2 installation (which you can find in the ORACLE_HOME/Rdbms/Admin/utlfile.sql file), you will see that in fact even "way" back in 10.2, the parameter names matched those in 11.2.
Which just proves once again that you are always better off actually checking the code compiled into the database than relying on the (any) documentation!