SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Code: 17439. When I'm trying to insert in a table with listagg

Luis AlvaraezNov 13 2017 — edited Nov 13 2017

Hi,

I'm trying to insert a register in a table from other table with listagg.

insert into proc_agents(grp)
        (select  listagg(grpname,',') within group (order by grpname)  from CMS.AGEN where 
                nodeid='try');
commit;

But it gives me an error:

13:04:36 [/* - 0 row(s), 0.000 secs] [Error Code: 17439, SQL State: 99999] Tipo SQL no válido: sqlKind = UNINITIALIZED

My grp is varchar2(4000).

I dont know why gives me these error? Someone could help me please? Thanks and sorry for my English!

This post has been answered by Mustafa KALAYCI on Nov 13 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2017

Added on Nov 13 2017

7 comments

1,830 views