Skip to Main Content

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!

error with Shuttle in APex 5

3484428Jun 11 2017 — edited Jun 13 2017

Hello,

Can you help me please with this error?

  • Invalid numeric value 2:3 for column ID_PRODUS

Technical Info (only visible for developers)

  • is_internal_error: false
  • apex_error_code: WWV_FLOW_DML.DML_INVALID_NUMBER_ERR
  • ora_sqlcode: -6502
  • ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
  • component.type: APEX_APPLICATION_PAGE_PROCESS
  • component.id: 1962120770880735
  • component.name: Process Row of FACTURI_FURNIZORI
  • error_backtrace:
    ORA-06512: at "APEX_050100.WWV_FLOW_DML", line 1559

I have a Shuttle with a list of values and if I choose just one value from the Shuttle (it'a about a bill with one or more products on it) => it works fine, I have the good registration,

but if I want to have more values from my Shuttle (in order to have a bill with more products on it), I have this error.

On Apex 4 it worked, but if I do exactly the same things on Apex 5 apparently it doesn't work because of that error.

I hope I can get an answer.

Thanks.

pastedImage_3.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2017
Added on Jun 11 2017
2 comments
627 views