Two problems happened in my testing process. I checked the help docs and forum lists, but didn’t find helpful information. I posted the problem here and ask for your help.
1 In the code procedure, there are some code like this:
PRAGMA EXCEPTION_INIT(RowExists, -00001);
I would like to verify whether this exception could be thrown out, I defined a test case and running it but failed. Does this kind of exception can’t be tested?
2 In my test case definition, I have an input of Number(Number data type, the size was defined as 20) like this, 9223090561878066167, I define the output to query whether this value has been updated in the table. But after the execution, the value inserted into the table became to 9223090561878070000. Is there any place I can define to not allow this automatic ROUND happens?
Very appreciate your any assistance.