Hi, All:

I create a stored procedure on Sybase ASE, and I want to call it inside a query like this:

select * from tableA a, tableB b

where a.id=b.id
and (exec storeprocedure)


My question is: can I write this query using HQL? If not, can I have this query using SQL?

Thanks!

Hi


I have tried it in SQL but couldnt .I am getting Invalid syntax error.I think that you cannot do it in HQL .

Hi shantha,


you could call session.connection() connection to call Proc . dont use in HQL