I'm wondering if its possible, and if so, how to get the 'nextVal' from an Oracle sequence. I cannot seem to figure out what to map into the mappings and such so that I can perform the sql command:

where 'sequence' is the name of the oracle sequence.
Any help would be great. I'm supposed to take the value from the sequence and add it to a three letter string, depending on what is going into the database.

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
Oracle 9i
The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

just write it in a jdbc dao call.