Toad World® Forums

Error for grid operations on tables that contain a dollar sign in their name

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

It’s only 5:30 AM here in DFW where John is located – so will be a few hours before he can reply. But that looks like a legit bug
J

From: Kevin Angus [mailto:bounce-KevinAngus@toadworld.com]

Sent: Thursday, January 02, 2014 5:32 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Error for grid operations on tables that contain a dollar sign in their name

Error for grid operations on tables that contain a dollar sign in their name

Thread created by Kevin Angus

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

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

Thanks Kevin, it will be fixed next beta. Looks like # will also cause the same problem.

Confirmed fixed in .11

Cheers,

Kevin