MATERIALIZE HINT does not work with ODP.NET 10.2.0.2
Hi,
ORACLE SERVER 10.2.0.3 on SUN SOLARIS 5.10 INTEL X86_64
CLIENT WINX 10.2.0.2
If a Query using WITH Clause and --+ MATERIALIZED hint with bind parametes is executed with PL/SQL-Developer or SQL*PLUS the Query plan shows
the Plan Step (V$SQL_PLAN) TEMP TABLE TRANSFORMATION ;
but if the *same* sql is executed with ODP.NET it does not materialize;
Optimzer-Environment and Session nls setting are the same,
what could be the reason????
any idea
/Karl
ORACLE SERVER 10.2.0.3 on SUN SOLARIS 5.10 INTEL X86_64
CLIENT WINX 10.2.0.2
If a Query using WITH Clause and --+ MATERIALIZED hint with bind parametes is executed with PL/SQL-Developer or SQL*PLUS the Query plan shows
the Plan Step (V$SQL_PLAN) TEMP TABLE TRANSFORMATION ;
but if the *same* sql is executed with ODP.NET it does not materialize;
Optimzer-Environment and Session nls setting are the same,
what could be the reason????
any idea
/Karl
0