delete_task.sql

-- FUNCTION: code_src.delete_task(numeric)

-- DROP FUNCTION code_src.delete_task(numeric);

CREATE OR REPLACE FUNCTION code_src.delete_task(
	taskid numeric)
    RETURNS text
    LANGUAGE 'plpgsql'

    COST 100
    VOLATILE SECURITY DEFINER 
AS $BODY$
DECLARE     
  o_status text;
  o_message text;  
  o_json text;    
BEGIN
/*
  Summary: 
    Delete a task.
  Testing:
    SELECT delete_task(1000000036)
*/
    o_status = 'OK';
    o_message = '';	
	
	DELETE FROM ige_task
	  WHERE task_id = $1;
/*	-- Beginning of updating Oracle
    DELETE FROM imaint_anchor.ige_task
	  WHERE task_id = $1;
    -- End of updating Oracle  */
    SELECT row_to_json(c) INTO o_json
	FROM
	(
	  SELECT o_status status, 
	       o_message message		  
	) c;
	RETURN o_json;
EXCEPTION      
  WHEN OTHERS THEN
    o_status = SQLSTATE;
	o_message = SQLERRM;	
	SELECT row_to_json(c) INTO o_json
	FROM
	(
	  SELECT o_status status, 
	         o_message message
	) c;
    RETURN o_json;
END;  
$BODY$;

ALTER FUNCTION code_src.delete_task(numeric)
    OWNER TO network;

GRANT EXECUTE ON FUNCTION code_src.delete_task(numeric) TO anchorto_run;

GRANT EXECUTE ON FUNCTION code_src.delete_task(numeric) TO network;

REVOKE ALL ON FUNCTION code_src.delete_task(numeric) FROM PUBLIC;