Nested Table Query using public synonym doesn't work...
Posted: Mon 26 Jul 2010 15:50
Setup info:
Execute the following:
The above query works in SQL*Plus but not in ODAC.
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;Code: Select all
SELECT a_nt(a_t('LB',1),a_t('KG',100)) FROM dual;