Does Hibernate support PL/SQL?

isma · **Joined:** Wed Mar 01, 2006 11:30 am **Posts:** 2

Is PL/SQL code supported in Hibernet. If it is supported how manage and how uses Hibernate de PL/SQL code?

Thanks

kgignatyev · **Posted:** Wed Mar 01, 2006 12:46 pm

As native SQL
http://www.hibernate.org/hib_docs/v3/re ... rysql.html

jt_1000 · **Posted:** Wed Mar 01, 2006 1:24 pm

Also, in your class mapping you can add
items like
<sql-query...>
<sql-insert...>
<sql-update...>
<sql-delete...>

that would specify the stored procedure and/or function that you're calling for those operations.
Check out v3 reference.pdf pg 166 for more info.
http://www.hibernate.org/hib_docs/v3/reference/en/pdf/hibernate_reference.pdf

Just EDITED with:

sorry - the query section that kgignatyev referenced also covers this (it is more than just querying.. but also includes DML).

isma · **Joined:** Wed Mar 01, 2006 11:30 am **Posts:** 2

Im very thank you about two replys :)

They are good, it was just i needed.