The Custom DQL functions don't have access to the platform nor the current connection as far as I know - you will most probably either have to:
- reproduce the function in your current schema - override the custom DQL function so that it actually has the hardcoded schema owner in its 'getSql' method Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 20 February 2014 13:12, George DRAGU <[email protected]> wrote: > Hello, > > We have an application with 2 backend databases (up until now) MS SQL and > Oracle. > All the objects in the database share the same names, even the user > defined functions and stored procedures. > The problem is when we use something like: > $qb > ->select('a.id as id, a.code as code, Test(a.id) as label') > Where 'Test' is a user defined function. This works well with Oracle but > in MS SQL we have to prefix with schema owner (dbo) > > Has anyone had this problem? Could you share with us your experience? > > Thanks a lot, > George. > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/groups/opt_out.
