Hi,
TOAD Beta 12.5.0.10
There seems to be a problem in the beta with data grid operations on tables that contain a dollar sign in their name.
For example,
CREATE TABLE ex$ample (col1 varchar2(30));
In a data grid click the plus to add a row, then click the tick to post it, you get an error.
The spooled SQL is
INSERT INTO “MYSCHEMA”.“EX”
(“COL1”)
VALUES
(:“COL1”)
Error: ORA-00942: table or view does not exist
Similarly when updating an existing row you get an error as soon as you type into a field:
SELECT “COL1” AS “_1” FROM “MYSCHEMA”.“EX”
WHERE
“ROWID” = :“Old_ROWID”
FOR UPDATE NOWAIT
Error: ORA-00942: table or view does not exist
So, TOAD is not seeing the dollar sign or anything following it in the table name.
Works OK in TOAD 12.1.0.22.
Cheers,
Kevin