OTP with Oracle

Generate an OTP Token (One Time Password) with Oracle

Example in Oracle:

	l_url varchar2(200) := 'http://www.afilnet.com/api/http/?class=otp'||'&'||'method=generateotp'||'&'||'user=user'||'&'||'password=password'||'&'||'type=number'||'&'||'destination=34600000000'||'&'||'time=1'||'&'||'timetype=days'||'&'||'length=6'||'&'||'otpformat=all'||'&'||'output=';
	l_req utl_http.req;
	l_resp utl_http.resp;
	l_text varchar2(32767);
	l_req  := utl_http.begin_request(l_url);
	l_resp := utl_http.get_response(l_req);
			utl_http.read_text(l_resp, l_text, 32766);
		end loop;                
		when utl_http.end_of_body then

See example in:

PHP Java C Sharp Unix Ruby on rails Python Android Objective C / iPhone SQL Server Oracle Node JS Go lang Scala lang Swift

Generate an unique use password (OTP - One-Time Password)

Parameter Description Compulsory / Optional
class=otp Class requested: Class to which the request is made Compulsory
method=generateotp Class method requested: Method of the class to which the request is made Compulsory
user User and e-mail of your Afilnet account Compulsory
password Password of your Afilnet account Compulsory
type Type of group (email or mobile) Compulsory
destination Mobile number or destination email Compulsory
time Number of days, weeks, months or years Optional
timetype Type of time (Posible value: days, weeks, months o years) Optional
length Length of the password to generate Optional
otpformat Format of the password to generate, if it includes all the characters, only numbers or only letters (all, numbers, letters) Optional
output Output format of the result Optional

When you make requests you will receive the following fields:

  •  status
  •  result (if status=success), here you will receive the following values:
    • No additional values will be sent to you
  •  error (if status=error), here you will receive the error code

The possible error codes are listed below

Code Description
MISSING_USER User or email not included
MISSING_PASSWORD Password not included
MISSING_CLASS Class not included
MISSING_METHOD Method not included
MISSING_COMPULSORY_PARAM Compulsory parameter not included
INCORRECT_USER_PASSWORD Incorrect user or password
INCORRECT_CLASS Incorrect class
INCORRECT_METHOD Incorrect method
INCORRECT_TIME_TYPE Incorrect type of time (possible values: days, weeks, months or years)
INCORRECT_TYPE Incorrect type. The type must be mobile or email
  • class: otp
  • method: generateotp
  • user: user
  • password: password
  • type: number
  • destination: 34600000000
  • time: 1
  • timetype: days
  • length: 6
  • otpformat: all
  • output:
IMPORTANT INFORMATION ABOUT COOKIES: If you continue to use this web we will assume that you accept the terms of use. You will find more information in our Cookies Policy. Continue