title: create a function via nativeQuery
body: <p>I'm trying to insert a function on database via native query, like this</p>
  
  <pre><code>EntityManagerImpl entityManagerFunctionConta = (EntityManagerImpl) GermantechEntityManager.getEntityManager();
  EntityTransaction transactionFunctionConta = entityManagerFunctionConta.getTransaction();
  String functionConta = "CREATE OR REPLACE FUNCTION saldo_anterior_conta(dt_inicial date, id_conta bigint, id_empresa bigint) " +
   "RETURNS numeric AS " +
   "$BODY$ " +
   "declare " +
   "saldo_anterior numeric(14,2);" +
   "begin " +
   "select coalesce(sum(valor), 0) into saldo_anterior " +
   "from saldoinicialconta " +
   "where data &lt; dt_inicial and empresa_id = id_empresa and conta_id = id_conta; " +
   "return saldo_anterior;" +
   "end;" +
   "$BODY$ " +
   "LANGUAGE plpgsql VOLATILE COST 100;" +
   "ALTER FUNCTION saldo_anterior_movimentacao(date, bigint, bigint) OWNER TO postgres;";
  
  transactionFunctionConta.begin();
  entityManagerFunctionConta.createNativeQuery(functionConta).executeUpdate();
  transactionFunctionConta.commit();
  </code></pre>
  
  <p>but the following exception is thrown</p>
  
  <pre><code>Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException
  Internal Exception: java.sql.BatchUpdateException: Entrada em lote 1 &lt;unknown&gt; foi abortada. Chame getNextException para ver a causa.
  Error Code: 0
      at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:882)
      at org.eclipse.persistence.internal.databaseaccess.DynamicSQLBatchWritingMechanism.executeBatchedStatements(DynamicSQLBatchWritingMechanism.java:144)
      at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.writesCompleted(DatabaseAccessor.java:1714)
  </code></pre>
  
  <p>is there something wrong with the function? can we run a command like this via nativeQuery?</p>