如何使用DQL在symfony2.0 2.2中正确调用自制的SQL函数？

Question

我在oracle数据库中开发了一个SQL函数：

     create or replace function test (var in number) return number  is
     begin 
     return 888;
     end;
     /

在sql中，我可以这样调用此函数：

    select test(1) as res from dual;

如何在symfony2.0.2.2中正确调用SQL函数？我试过这个：

        $query = $this->createQueryBuilder('DUAL')->select("FUNCTION('test1',1) as res");
        die(var_dump($query->getQuery()->getResult()));

它可以工作，但是它的响应太多了，我不知道为什么：

    array(15) { [0] => array(1) { 'res' => string(3) "888" } [1] => array(1) { 'res' => string(3) "888" } [2] => array(1) { 'res' => string(3) "888" } [3] => array(1) { 'res' => string(3) "888" } [4] => array(1) { 'res' => string(3) "888" } [5] => array(1) { 'res' => string(3) "888" } [6] => array(1) { 'res' => string(3) "888" } [7] => array(1) { 'res' => string(3) "888" } [8] => array(1) { 'res' => string(3) "888" } [9] => array(1) { 'res' => string(3) "888" } [10] => array(1) { 'res' => string(3) "888" } [11] => array(1) { 'res' => string(3) "888" } [12] => array(1) { 'res' => string(3) "888" } [13] => array(1) { 'res' => string(3) "888" } [14] => array(1) { 'res' => string(3) "888" } } 

Answer 1

请查看有关向Symfony添加自定义DQL函数的相应文章：

http://symfony.com/doc/current/cookbook/doctrine/custom_dql_functions.html

http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/cookbook/dql-user-defined-functions.html