Tabbed result in SQL Window shows wrong CLOB

[jhughes]

I discovered a glitch when running multiple SQL statements from the SQL window. I did a quick search on the forums and didn't see this posted, but please let me know if I missed it.

Our 10g db table structure is a simple parent/child table relationship where both the parent and child have a CLOB in them. I have the following two SQL statements coded.

SELECT *
FROM child
WHERE primary_key_col = 528;

SELECT *
FROM parent
WHERE primary_key_col = 1331;

I select both and hit F8 to run. The results come back on the separate tabs. When I click the ... on the first tab to view the CLOB, it is actually showing me the CLOB from the parent table. If I run the SELECT for the child table alone, it correctly shows me the CLOB in the child table.

If I switch the order of the SELECT statements around, so that the child table is last and run both, both tabs show the CLOB from the child table instead.

Thanks
Jason

PSD info
PL/SQL Developer
Version 7.0.1.1066 (MBCS)
178.30864 - 20 user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 523,760 kB (101,312 available)
Paging file : 885,632 kB (440,272 available)
Virtual memory : 2,097,024 kB (1,977,144 available)

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

Preferences
Session mode: Multi
OCI Library: C:\oracle\ora92\bin\oci.dll
Use OCI7: False

Plug-Ins

Homes
OraHome92 (C:\oracle\ora92)
OraHome92_1 (C:\oracle\ora92_1)

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

TNS File
c:\oracle\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0
Character size: 1 byte(s)

 

[Marco Kalter]

That doesn't seem right. We'll fix it.