Langsung ke konten utama

Call procedure input param

 $srv_req_id          = $data['srv_req_id'] ;
 $employee_id         = $data['employee_id'];
 $user_id             = $data['user_id'];  
 
 $result['status']  = TRUE;
 $result['message']  = 'Sukses assigned Ticket ke employee';
 
 try{
   $sql = "CALL SMS_SP_SPKTS_AssignedTo($srv_req_id,$employee_id,$user_id)";    
   $stmt  = oci_parse($this->db->conn_id, $sql);    
  
  if(@!oci_execute($stmt)){
   $err = oci_error($stmt);
   
   throw new Exception($err['message']);
  }
  
 
 }  
 catch (Exception $e) {

 
  $result['status']   = FALSE;
  $result['message']  = $e->getMessage(); 
 
 
 }
 return $result; 

Komentar

Popular Posts

Extjs html class render

Ext.select('.datepicker').each(function(el){ new Ext.form.DateField({ allowBlank : true, renderTo: el, format:'m-d-Y', editable:false, width:140, fieldCls : 'tanggal x-form-field x-form-text x-trigger-noedit', }); }); Ext.select('.note').each(function(el){ new Ext.form.field.TextArea({ allowBlank : false, renderTo: el, grow : true, hideLabel : true, fieldCls : 'pesan x-form-field x-form-text x-trigger-noedit', }); });