0 Replies Latest reply: Mar 28, 2014 1:29 AM by Boheme Olivier RSS

    Parameter list in SQL native queries

    Boheme Olivier

      I need to migrate from Toplink 10 to EclipseLink.


      In my "old" project, I have some SQL native queries like '...... where field in #pFieldValues'

      #pFieldValues is an arraylist/vector.


      It was working perfectly with TopLink 10, but now it fails with 'Oracle Error' 'Invalid column type'.

      How can I achieve this now with EclipseLink?  (I don't want to use EJBQL queries (or JPQL queries).


      Thanks