Query containing a WITH clause returns "SQL statement doesn't return rows" (4296264)

Chat now with support

Return

Title

Query containing a WITH clause returns "SQL statement doesn't return rows"
Description

Executing a query containing a WITH clause returns the following message.

"SQL statement doesn't return rows"

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.

Recommended Content

Product(s):: Toad for Oracle
10.1, 10.0, 9.7.2, 9.7.0, 9.6.1, 9.6.0, 9.5.0, 9.1.0, 9.0.1, 9.0.0, 8.6.1, 8.6.0.38, 8.5.3.2, 8.5.1.6, 7.5.4.17, 8.5.0.50, 7.5.3.57, 8.0.0.47, 7.6.0.1, 7.5.2.0, 7.5, 7.4.0.3, 7.4.0.1, 7.3, 7.2, 7.1, 7.0, 6.4.0.0, 6.5.0.0, 6.3.0.0; SQL Navigator for Oracle
6.2.1, 6.2, 6.1.0.1094, 6.0.0.1055, 5.5.4.847, 5.5.3.791, 5.5.2.742, 5.5.1.737, 5.5.0.713, 5.1.0.655, 5.0.0.607, 4.5.1.538, 4.5.1, 4.5.0.534, 4.4.1.501, 4.4.0.500, 4.3.2.476, 4.4, 4.3.2, 4.3.1, 4.3, 4.2, 4.1.2, 4.1c1, 4.0c3, 4.0c2, 4.0c1, 3.2d11, 3.2, 2.0x