14 July 2010
Issue raised by player regarding 12 July quiz(505)
I received an email with the following statement: "Hello Steven and PLSQL challenge team, I reckon that the 3rd option in a recent quiz (12 Jul 2010) was incorrect, because "Any program unit" (2nd requirement in a question) may include client PL/SQL calls, like from Oracle Forms/reports where you cannot use default values for actual parameters." And here is my response: in our assumptions for the quizzes, we state: "The session and the environment in which the quiz code executes has enabled output from DBMS_OUTPUT, and can reference only those datatypes, programs and database objects defined in the context of the quiz or are available in a default installation of the Oracle instance." Therefore, while what you say may be true, it does not apply to this or any other PL/SQL Challenge quiz, unless we explicitly introduce the idea of running client-side PL/SQL in that quiz. Please let me know what you think.