Hello:) I am trying to update a table with values from a form that is submitted. For this I use the following page process fired when the page is submitted: begin UPDATE TABLE SET COLUMN1 =:P8_COLUMN1, COLUMN2 =:P8_COLUMN2 WHERE TBL1ID =:P8_TBL1ID; end; When submitting the page I'll get the error ORA-06502: PL/SQL: numeric or value error. I already checked if some values do not correspond to the table data type. But I don't know at which line the error occurs, because it is not explicitly shown in the debug information. I only receive information about which error is involved in which process. But not which value triggers this error - component: APEX_APPLICATION_PAGE_PROCESS Insert into DB_Tables (22664009596071946) Can you tell me how I can see which value triggers this error or how I can avoid this error otherwise? I would really appreciate any help:)
Discy Latest Questions
Hello sir, I am very grateful for your posts, it helps me a lot. I have one question: In my application, I use the data load wizard for uploading data. I want to adjust the content in the error column of the data load result page in the data load wizard progress so that when the user sees the error, they will understand what it is. For example, when reporting a constraint error, if the default, apex will display "ORA-00001: unique constraint (...) violated" I want to replace it with my message is"Duplicated data, check again." and other errors. If it is the default, we can not adjust it so do you have any solution for this problem? THANKS, A LOT.