CREATE PROCEDURE P_S_NFE_PREENCHENUMERO (
codigo varchar(100),
vezes integer,
simbolo varchar(100),
"TYPE" char(1))
returns (
result varchar(100))
as
declare variable tamanho integer;
begin
if (type='E') then
begin
while (char_length(:codigo) < :vezes) do
begin
codigo = simbolo||codigo ;
end
result = :codigo ;
end
if (type='D') then
begin
while (char_length(:codigo) < :vezes) do
begin
codigo = codigo||simbolo ;
end
result = :codigo ;
end
suspend;
end