Execute select query (longer than 4000 chars) on oracle from java using hibernate -

Execute select query (longer than 4000 chars) on oracle from java using hibernate -

i have long select query, oracle database (11g) , hibernate 3. on java side have query:

string query = "select {some different columns} {some tables} param1='{some string longer 4000 chars}' , param2= ...";

how can execute , results using hibernate session? if utilize createsqlquery, get:

java.sql.sqlexception: ora-01704: string literal long

and prefer solution, doesn't utilize session.connection() because it's deprecated.

thanks!

java hibernate oracle11g clob