0 Replies Latest reply on Mar 24, 2008 2:26 AM by wang yufeng

    how to call oracle function with Hibernate JPA from JBoss se

    wang yufeng Newbie

      Is it possible to call oracle function other than procedure with Hibernate JPA? How?

      I'm developing a web app with JBoss seam + Hibernate JPA, and I'd like to call an oracle function with JPA 's entityManager.createNativeQuery API。 But I failed.
      The code has follows:
      //===Java code with JPA
      entityManager.createNativeQuery("{call get_filelist(?)}")
      .setParameter(1, dirName)
      .getSingleResult();

      The oracle function is defined as follows:
      //===Oracle function def

      CREATE OR REPLACE FUNCTION get_filelist (p_path IN VARCHAR2)
      RETURN VARCHAR2
      AS
      LANGUAGE JAVA
      NAME 'FileList.RunThis(java.lang.String) return String';

      The error code is as follows:

      PLS-00221: 'GET_FILELIST' is not a procedure or is undefined .

      In fact, I can see the get_filelist with sqlplus when typing 'desc get_filelist'.

      Thanks for your suggestion.