Calling an Oracle Stored Function from Hibernate

Question

I have an Oracle Editionalble Function (that I cannot change) which I need to call from Hibernate.

CREATE OR REPLACE EDITIONABLE FUNCTION
"SCHEMA"."FUNCTION_NAME"
(
  var1 IN CHAR DEFAULT NULL ,
  var2 IN CHAR DEFAULT NULL ,
  var3 OUT CHAR
)
RETURN NUMBER
AS
  ...
END;

Unfortunately, I have no idea how to do this. I saw a couple of posts on here about Session.doWork(), but I couldn't figure out how to make that work here.

andy weiss · Accepted Answer · 2016-02-13 00:53:45Z

1

As long as the function does not change data you can use the dual table to call it from a query.

select schema.function_name(:bind1,:bind2,:bind3) from dual;

answered Feb 13, 2016 at 0:53

andy weiss

364 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pankaj · Accepted Answer · 2016-02-13 08:12:01Z

1

You can try something like:

Query query = session.createSQLQuery(
    "CALL myfunc(:param1)")
    .setParameter("param1", "xyz");

answered Feb 13, 2016 at 8:12

Pankaj

6555 silver badges9 bronze badges

Collectives™ on Stack Overflow

Calling an Oracle Stored Function from Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related