[firebase-br] IbExpert - Extrair MetaData

[Gilson Silva]

       Amigo,  o ibExpert, ibConsole, iboConsole e outros aplicativos que 
geram metadata, costumam extrair o fonte de um procedimento desta forma, 
provavelmente se vc olhar mais abaixo vc terá o ALTER PROCEDURE referente 
aos seus procedimentos, com o código completo.
       Você deve ter algo assim:

SET TERM ^ ;

/******************************************************************************/
/***                           Stored Procedures 
***/
/******************************************************************************/
CREATE PROCEDURE ALTERA_VALOR_GENERATOR (
    PAR_GENERATOR VARCHAR(35),
    PAR_VALOR INTEGER)
AS
BEGIN
  EXIT;
END^

SET TERM ; ^

/******************************************************************************/
/***                           Stored Procedures 
***/
/******************************************************************************/

ALTER procedure ALTERA_VALOR_GENERATOR (
    PAR_GENERATOR varchar(35),
    PAR_VALOR integer)
as
begin

  execute statement 'SET GENERATOR '|| :par_generator || ' to ' ||
                     coalesce(:par_valor,0) || ';';

end^