factored subquery

[Paul C]

I have version pl/sql developer 5.0.1.480 with oracle 9.2.0.6.

My query has a subquery factoring clause and does not return rows. No error message is displayed. A simple example below does not return anything.

with x (select sysdate from dual)
select * from x

What can I do?

 

[Flieger]

Have just started a similar thread:
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=002821

 

[Paul C]

These are my info:

Info
--------------------------------------------
PL/SQL Developer
Version 5.0.1.480
09.15750 - Unlimited user license
Windows 2000 version 5.0 (build 2195) Service Pack 4

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Aliases
diadbmnj
diadbmny
diadbmpa
diambeta
diambsln
diaprdapipa
diaprdmd
diaprdne
diaprdnj
diaprdny
diaprdpa
diaprlapipa
diaprlmd
diaprlne
diastgapipa
diastgmd
diastgne
diastgnj
diastgny
diastgpa
diatrnapipa
diatrnmd
diatrnne
diatrnnj
diatrnny
diatrnpa
diatstapipa
diatstmd
diatstne
diatstnj
diatstny
diatstpa
dss
dwprd
eds
metaframe
miscprd
miscstg
misctst
rcvct
tdoraserver

Homes
OraHome81 (C:\oracle\ora81)

DLLs
C:\oracle\ora81\bin\oci.dll

TNS File
C:\oracle\ora81\Network\Admin\tnsnames.ora

Using
Home: OraHome81
DLL: C:\oracle\ora81\bin\oci.dll
OCI: Version 8.1
Oracle9i Enterprise Edition Release 9.2.0.6.0

Registry
================================================

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora81
ORACLE_HOME_NAME = OraHome81
API = C:\oracle\ora81\dbs
ORACLE_GROUP_NAME = Oracle - OraHome81
NLS_LANG = NA
OLEDB = C:\oracle\ora81\oledb\mesg
OO4O = C:\oracle\ora81\oo4o\mesg

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome81
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome81
PATH = C:\oracle\ora81
NLS_LANG = NA

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome81
ORACLE_HOME_NAME = OraHome81
ORACLE_HOME = C:\oracle\ora81
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_HOME_KEY = Software\ORACLE\HOME0
SQLPATH = C:\oracle\ora81\dbs
MSHELP_TOOLS = C:\oracle\ora81\MSHELP

SOFTWARE\ORACLE\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRSet = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\ora81\MSHELP\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\ora81\oo4o

Path
===============================================
C:\oracle\ora81\bin
C:\Program Files\Oracle\jre\1.1.7\bin
C:\Program Files\Oracle\jre\1.3.1\bin
C:\WINNT\system32
C:\WINNT
C:\WINNT\System32\Wbem
C:\Program Files\Executive Software\DiskeeperWorkstation\
C:\WINNT\system32\nls
C:\WINNT\system32\nls\ENGLISH