<sql-query name="sqlcondition" callable= "true">
<return-scalar column="zeroornot" type="long"/>
{ ? = call FPI_UI_UTILS_PKG.check_fpi_deals_where_cond(?, ?) }
</sql-query>

FPI_UI_UTILS_PKG.check_fpi_deals_where_cond(?, ?)
first function takes parameter, second is out argument.
how can i work this out? also it returns a number which should be stored in zeroornot?


the second parameter is out parameter
how to retreive out parameters?

FPI_UI_UTILS_PKG.check_fpi_deals_where_cond takes two parameters. second is out parameter

it also returns a number

bump

{ ?= call FPI_UI_UTILS_PKG.check_fpi_deals_where_cond(?,?)}


SessionFactory HibernateSupport = new Configuration().configure() .buildSessionFactory();
Session s = HibernateSupport.openSession();
String gregor ="mesg"
Query q = s.getNamedQuery("getSummary");;
// q.setString("krikor");
q.setParameter(1,gregor );
q.setParameter(2,gregor);
q.registerOutParameter(1, java.sql.Types.TINYINT);
List l = q.list();

can someomne help?