pessoal, tenho um script ant que dropa as funções criadas no meu banco.
<transaction><![CDATA[
begin
for funcoes in (select object_name ,'drop function '|| object_name as dropar from all_objects
where owner = '${oracle.username}'
and object_type = 'FUNCTION') loop
begin
execute immediate funcoes.dropar;
exception when others then
dbms_output.put_line('Erro ao tentar dropar função ->'||funcoes.object_name);
end;
end loop;
end;
]]></transaction>
o erro que estou obtendo é o seguinte:
C:\Higienizacao\scriptsDbOracleAnt\scripts\delete\delete-build.xml:25: java.sql.SQLException: ORA-06550: line 1, column 209:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
. ( * @ % & = - + ; < / > at in is mod remainder not rem
return returning <um expoente (**)> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ between into using ||
multiset bulk member SUBMULTISET_
ja tentei encoding de arquivo, mudar a sintaxe do meu bloco pl/sql e busquei no forum mas as respostas que encontrei nao funcionaram no meu caso.
agradeço a ajuda.