-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Call PL/SQL funct for fetching a column & others from DB
PostPosted: Mon Dec 22, 2008 2:32 am 
Newbie

Joined: Mon Dec 22, 2008 2:12 am
Posts: 1
Location: India
Hi all,
I am new to hibernate.
I need to fetch list of rows from db in which one field should be fetched from pl/sql function and all the others from date base colums.
How to call this pl/sql function in each row for fetching my customized column and other column from DB.

eg:
I want to call this kind of query using hibernate.

select student_id,student_name,student_class,is_scholer_ship_eligible(student_id) as scolership_eligiblity from student where student_class = 10;
Here student_id,student_name,student_class come from db column and
scolership_eligiblity comes from a function return.

In the above example the function is_scholer_ship_eligible is called passing student_is as parameter.Is this possible to call the same kind of scenario using hibernate.

Kindly assist me.

Thanks and Regards
Navas Khan.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.