Zottis/BD Externo

  BANCO      = 'externo';/*'192.168.1.10:D:\BD\EXTERNO.FDB';*/
  USUARIO_BD = 'SYSDBA';
  SENHA_BD   = 'masterkey';

  EXECUTE STATEMENT ( 'EXECUTE PROCEDURE SP_GEN_AUDITORIA;')
         ON EXTERNAL :BANCO
         AS USER :USUARIO_BD PASSWORD :SENHA_BD
   WITH COMMON TRANSACTION
   INTO :CODIGO_ ;

   SQL = 'INSERT INTO auditoria ( CODIGO, DATA_CAD, HORA, COD_USUARIO, TABELA, OPERACAO, CHAVE, ENDERECO, NETWORK_PROTOCOL) VALUES ('
                               || :CODIGO_ ||','''|| CURRENT_DATE ||''','''|| CURRENT_TIME ||''','||  :usuario  ||','''||  :tabela_ ||''','''
                               || :operacao_ || ''','||  :chave_ ||','''|| :endereco_ ||''','''||  :NETWORK_PROTOCOL_|| ''');';

/*create external file 'd:\arquivo-sql.txt' (SQL);*/


  EXECUTE STATEMENT SQL
        ON EXTERNAL :BANCO
         AS USER :USUARIO_BD PASSWORD :SENHA_BD
   WITH COMMON TRANSACTION;