Home » SQL & PL/SQL » SQL & PL/SQL » Need help validating a credit card (Sql plus)
Need help validating a credit card [message #315867] Wed, 23 April 2008 01:27 Go to next message
CiroM
Messages: 1
Registered: April 2008
Location: California
Junior Member
I have to creat a function to validate a 16 digit cc number with the mod-10 algorithm returning a boolean.Anybody knows how to do this????
Re: Need help validating a credit card [message #315868 is a reply to message #315867] Wed, 23 April 2008 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the algorithm.

Regards
Michel
Re: Need help validating a credit card [message #315870 is a reply to message #315867] Wed, 23 April 2008 01:33 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Check out this link...

This is in PHP but i think you can understand the concept of MOD 10 algrithm and can easily implement it using oracle.

http://www.devarticles.com/c/a/PHP/Creating-a-Credit-Card-Validation-Class-With-PHP/
Re: Need help validating a credit card [message #315888 is a reply to message #315870] Wed, 23 April 2008 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So your proble is just to write this in PL/SQL?
What did you try?

Regards
Michel
Re: Need help validating a credit card [message #316008 is a reply to message #315870] Wed, 23 April 2008 08:40 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Isn't it strange that in your link the credit card number is 15 digits? The ones I know are all 16 digits.

Regards
Michel
Previous Topic: recursive date problem (Merged 3)
Next Topic: SQL join problem
Goto Forum:
  


Current Time: Thu Dec 08 00:03:49 CST 2016

Total time taken to generate the page: 0.16071 seconds