Is it possible to execute SQL statement when record reaches precise conditions eg. I want to insert record to another calling list when Record_status != Updated and attempt = 3
We need to send SMS to clients that we need to contact them.
insert into CB_SMS (call_result,contact_info,contact_info_type,phone,phone_type,daily_from,daily_till,record_type,record_status,tz_dbid, attempt,campaign_id,chain_id, chain_n,record_id,SMS_Message,SMS_SOURCE_NUMBER) VALUES (28,$MSISDN,4,$MSISDN,4,28800,72000,2,1,134,0,0,(select nvl(max(record_id)+1,1) from CB_SMS),0,(select nvl(max(record_id)+1,1) from CB_SMS),'Lorem ipsum',608900110)