Toad World® Forums

Quick build - "The table has not changed at all"


#1

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
OM employees;

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.

Any suggestions?

Thanks,
Mitch


#2

This should be fixed in the 1.8.1 release now production. What version do you have?


#3

We are using version 1.8.0.317.
I guess we’ll have to try to get the newest version.

Thanks,
Mitch