cast(multiset

[JohnnyBeGood]

Hi when I try to execute this statement

select cast(multiset (
select vaat_code_info
from pilo_tbl_val_attr vaat
where atgl_id = 8923)
as capg_type_tab_atgl_code_info
) from dual

in a sql window pl/sql Developer as a unexpected error and close.

Why ??

this statement works fine in sql*plus

this is the type that I use

create or replace type capg_type_tab_atgl_code_info
as table of varchar2(40)

and the table

create table PILO_TBL_VAL_ATTR
(
VAAT_ID NUMBER(10) not null,
VAAT_DT_VIG DATE not null,
VAAT_VAL VARCHAR2(80),
VAAT_DT_CREA DATE not null,
VAAT_USR_CREA VARCHAR2(30) not null,
VAAT_DT_MODIF DATE not null,
VAAT_USR_MODIF VARCHAR2(30) not null,
ATGL_ID NUMBER(10) not null,
VAAT_DESCR VARCHAR2(240),
VAAT_PLAGE_MIN VARCHAR2(80),
VAAT_PLAGE_MAX VARCHAR2(80),
VAAT_CODE_INFO VARCHAR2(8),
VAAT_IND_CAPITALE VARCHAR2(1),
VAAT_DT_EXPIR DATE,
VAAT_VAL_COMPO_DNM VARCHAR2(2000),
VAAT_ID_REMPLC NUMBER(10)
)

Jean boul

 

[Marco Kalter]

Oracle Net 8.0 has some collection related bugs that can cause errors. To verify this, try the same query on a PC with Net 8.1 or later.

------------------
Marco Kalter
Allround Automations