Get ORA-00942 error executing query and publishing results to TIC in automtion script (4238182)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Get ORA-00942 error executing query and publishing results to TIC in automtion script
Description

When executing a query, which contains a WITH clause and a LEFT OUTER JOIN, and publishing the results to a TIC (Toad Intelligence Central) server, an "ORA-00942: table or view does not exist" error is returned.

Here is an example of a query that would have this issue.
WITH T1 AS
(
SELECT * FROM DUAL
),
T2 AS
(
SELECT * FROM DUAL
)
SELECT *
FROM T1
LEFT OUTER JOIN T2 ON T1.DUMMY = T2.DUMMY
Cause

The issue is with the use of the WITH statement. We are parsing off the last select and running that and this is why we get the error.
Resolution

WORKAROUND:
Create a temp table in the execute SQL activity and then the last statement should be a select from the temp table.

STATUS:
This issue is fixed in Toad Data Point 5.0. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
Defect ID

QAT-12438

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title