What i have to do is that i have to insert some data in Oracle Temporary Table (GTT table) and then have to call a function which uses that table and returns an table of object.?

the problem with Gtt tables is that they are session specific and so when i use session.createQuery().save();
it saves that object in table . But when i call that function then it does not find any record in gtt table .?
Because may be the session uses different connection object every time so i am kinda stucked with this .

Please tell me any way to implement this in hibernate ??

When i do like
Retrieve connection object --- java.sql.Connection con = ((SessionImpl) session).connection();

The use prepared statement to insert record
and callable to ececute function then it works absolutely fine ..


But is this a hibernate way to do things ???


Please reply soon