Nested Table Query using public synonym doesn't work...

[gregoryliss]

Setup info:

Code: Select all

CREATE OR REPLACE TYPE A__T AS OBJECT
(
NAME VARCHAR2(30),
area NUMBER
) ;

CREATE PUBLIC SYNONYM a_t FOR a__T;

CREATE OR REPLACE TYPE a_nt  
   AS TABLE OF a_t;

Execute the following:

Code: Select all

SELECT a_nt(a_t('LB',1),a_t('KG',100)) FROM dual; 

The above query works in SQL*Plus but not in ODAC.

[bork]

Hello

We will investigate the possibility of adding this feature in one of the next builds/versions of ODAC.