-- PROCEDURE: testschema.hldprocess(integer)

-- DROP PROCEDURE testschema.hldprocess(integer);

CREATE OR REPLACE PROCEDURE testschema.hldprocess(
	INOUT v_tbad integer)
LANGUAGE 'plpgsql'
AS $BODY$
BEGIN
--  testschema.sample_id  is a sequence and  sample is a table
perform setval('testschema.sample_id', (select max(sample_id) from testschema.sample));

end;
$BODY$;