Getting an Error in cs_servicerequest_pub.Update_ServiceRequest
Hello,
I have written a code to update the service request but it fails
prlog('I''m here');
begin
select regexp_replace(i.ay_incident_no,'[^[[:digit:]into u_incident_number from dual;
select incident_id into u_incident_id from cs_incidents_all where incident_number=u_incident_number and external_attribute_11 = i.LG_JOB_CARD_NUMBER;
prlog('Incident Number to be updated: ' || u_incident_number);
prlog('Incident ID to be updated: ' || u_incident_id);
exception when others then
t_output:= substr(sqlerrm,1,3995);
prout('Incident Number Not Found: Going to Next Row');
begin
UPDATE xxaye_lg_data_in@xxlgintegration