jeffreykemp / clicksend-plsql-api Goto Github PK

send_test_sms

allows sending an sms immediately (bypass the queue), optionally with different settings (that don't change the stored settings).

I have developed one application in apex.oracle.com instance. so i want to configure this sms app. So Please suggest me how to configure it.

Thanks in advance.

Local variable anchor based on mailgun_settings, should be clicksend_settings

Allow quarantining messages from a non-prod (dev or test) database instance. e.g. suppress entirely, or send them to a designated recipient list.

• init - add p_prod_instance_name, p_non_prod_recipient
• send_sms, etc. - if p_prod_instance_name is set, compare to global_name;
  • if it matches, send the message as normal
  • if it doesn't match, treat this instance as a dev/test instance:
    • if p_non_prod_recipient is set, replace the recipient with just p_non_prod_recipient;
    • otherwise, don't send the message.

function get_usage (month in date, type in [subaccount, sms, voice, fax, post, email])
returns pipelined array of t_clicksend_stat (subaccount_id, username, count, price)

Hi,
i am facing issue "Network access denied by ACL ORA-24247". my Oracle Serv er is http. will it work only with https server?

i completed all the steps and set the the account as well.

Upload a file, optionally do a conversion.
function upload (file_content in blob, convert in [fax, mms, csv, post]) returns url

Add an overload for send_mms that accepts file_content as a blob instead of a url.

function get_subaccounts
returns pipelined array of t_clicksend_subaccount
(subaccount_id, api_username, email, phone_number, first_name, last_name, api_key, access_users, access_billing, access_reporting, access_contacts, access_settings, access_sms, access_email, access_voice, access_fax, access_post, access_reseller)

function get_languages
returns pipelined array of t_clicksend_lang
(lang_code, country_desc, female [Y or null], male [Y or null])

function get_sms_history (from_dt, until_dt)
returns pipelined array of t_clicksend_sms_history
(event_dt, mobile, message, status, sender, schedule_dt, status_code, status_text, error_code, error_text, message_id, message_parts, message_price, reply_email, custom_string, subaccount_id, country, carrier)