Bom dia a todos, gostaria de saber o que tem de errado na função abaixo:
CREATE OR REPLACE FUNCTION public.fnc_execute_ddl(pddl TEXT) RETURNS BOOLEAN
AS
$body$
DECLARE
lret BOOLEAN;
lsql TEXT;
BEGIN
lret := FALSE;
BEGIN
EXECUTE pddl;
COMMIT;
lret := TRUE;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
RETURN lret;
END;
$body$
LANGUAGE 'plpgsql';
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Transacao-de-DDL-tp4381706p4381706.html
Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
