TNS-12570 While running a query
Hi, I have a query that spans 3 tables with multiple sub selects. The result is a TNS-12570 when run through ODBC.
In SQLPlus, the query returns a few rows and pauses for a few seconds and returns more rows eventually finishing.
The environment is Windows 2008 Server VM and Oracle 11g.
The query is as follows :
select a.name, a.id, b.somedata, (select count(*) from table_c where table_c.id = a.id and table_c.value = 0) ,
(select count(*) from table_c where table_c.id = a.id and table_c.value = 1) ...
(select count(*) from table_c where table_c.id = a.id and table_c.value = 15)
In SQLPlus, the query returns a few rows and pauses for a few seconds and returns more rows eventually finishing.
The environment is Windows 2008 Server VM and Oracle 11g.
The query is as follows :
select a.name, a.id, b.somedata, (select count(*) from table_c where table_c.id = a.id and table_c.value = 0) ,
(select count(*) from table_c where table_c.id = a.id and table_c.value = 1) ...
(select count(*) from table_c where table_c.id = a.id and table_c.value = 15)
0