-
标题
EFormatter Invalid Syntax error in Test Builder: "Formatter Plus v4.8.8 @@@@@@@@@...". Issue with -
说明
I have 11g and am trying to use the result_cache clause. But when trying to open up Test Builder for such a program, I get an error:
Formatter Plus v4.8.8
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@"
and if you scroll down you will the script and a note that seem to show the script and that it is having trouble with the result_cache clause.
Example:
PACKAGE emplu11g
IS
FUNCTION last_name(
employee_id_in IN employees_for_11g.employee_id%TYPE)
RETURN employees_for_11g.last_name%TYPE
RESULT_CACHE;
END; -
原因
The parser/formatter does not yet recognize this syntax.There are some restrictions in using 11g and the usage of RESULT CACHE clause.
-
解决办法
The result_cache clause which will have to be commented out of the program headers for the initial creation of the test definition.
Example:PACKAGEemplu11gISFUNCTIONlast_name(employee_id_inINemployees_for_11g.employee_id%TYPE)RETURNemployees_for_11g.last_name%TYPE-- RESULT_CACHE;
END;Then Test Builder will accept this program.
Once you have created the test definition, you can "activate"/uncomment the result_cache clause once more. From that point on, you should be able to open Test Builder and Test Editor without seeing this error. If it happens again, though, you will need to go through the above steps again. -
其他信息
This applies to 11g support on Version 1.8.1 of Code Tester