I was testing a REMOVE_API package when I tried to use a Quick Build outcome (specifically, “The table has not changed at all” for a failed delete call). The test would not compile due to the error:
ORA-00923: FROM keyword not found where expected
When I looked at the code, it appears a line got wrapped in the middle of a string. For example:
CREATE TABLE Q##COPY_… AS SELECT … FR
If I manually remove the line feed/carriage return, the code compiles and runs fine. However, the next time I make a change to the test case, it reverts back to the broken statement.