Skip to Main Content

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

EAN-13 checksum

547235Jul 22 2007 — edited Jul 22 2007
I need to validate the input of EAN-13 check digit
I use FORMS 4.5 & ORCALE DB 9i

2741023456884 (this is the scanned input)

2*1
7*3
4*1
1*3
0*1
2*3
3*1
4*3
5*1
6*3
8*1
8*3

2 + 21 + 4+3+0+6+3+12+5+18+8+24=106

106/10 = 10 remainder 6

10-6 =4 ( 4 matches the check digit in the above input last digit)

Note: if the remainder is 0 then 10 -0 = 10 and the check digit is the right most digit which is 0

Can any help me with this procedure, has any one did this before.

Thanks for you help in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2007
Added on Jul 22 2007
7 comments
5,807 views