APEX

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!

Insert multiple values into database (choose Allow select multiple values)

2765771Jun 21 2016 — edited Jun 21 2016

Hi all,

As I'm Oracle Apex newbie, I have problem with inserting multiple values into database.

From drop-down menu i need to select few values and then insert them into database. When I choose only 1 value then everything work correct.

When I select more than 1 value then I got an error "Invalid numeric value 67:68 for column "XYZ"."

I'm guessing insert statement looks : Insert into XYZ values (67:68),

Is it possible to handle with that? The best way would be 2 Insert statement, but the question is how to do it ?

Thanks in advance,

This post has been answered by Pars on Jun 21 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2016

Added on Jun 21 2016

#apex-discussions

3 comments

1,762 views