but its working properly..only problem is at


LET var_query1="select ba_action_id into var_ba_action_id from bam_alert_actions where ba_alert_id=var_ar_alert_id and ba_action_id like "||var_action_occured||"";
...