Forum Stats

  • 3,726,956 Users
  • 2,245,297 Discussions
  • 7,852,506 Comments

Discussions

How to load multiple values for POP LoV in form?

Pav1
Pav1 Member Posts: 36 Green Ribbon
edited April 11 in APEX Discussions

Hi!

I am using Oracle APEX 20.2, I am trying to find a way to load multiple values in POPUP LoV.

On form page I created new before header process and add code to get colon-separeted values in popup.

Sample code of load process:

IF :P45_ID IS NOT NULL THEN

SELECT listagg(t1.tag_name, ', ')within group( order by t1.id )

INTO :P45_POPUP

FROM tags_table t1

INNER JOIN link_table t2 ON t1.id = t2.tags 

INNER JOIN tasks t3 ON t2.tasks = t3.id

WHERE t3.id = :P45_ID;

END IF;

When I tried to open form I got:

ora_sqlerrm: ORA-01722: invalid number ORA-06512: at "APEX_200200.WWV_FLOW_LOV",

Tagged:

Best Answer

Answers

Sign In or Register to comment.