a really basic implementation for hibernate calls plsql function

i really need a basic hibernate implementation calls oracle plsql function. it must include configurations, dao and test class.

is there any example for that?

Did you try to get started with the official documentation, the section 16.2.2. Using stored procedures for querying also covers functions? I doubt you'll find exactly what your asking for. And if you face a specific problem, ask a more specific question.

References

• Hibernate Core Reference Guide
  • 16.2.2. Using stored procedures for querying