Hi all,

I know Hibernate3.x supports stored procedure now and I've tested it. But I still have some questions about SPs in Hibernate:
1. Will 2nd level cache work with SPs? I know if you have some native SQL query repeatly executed in your application, you can cache the query result. Is it same to SPs?
2. Is Hibernate aware of the updated table if SP changes the underlying data and update the cache if needed(I think it is different from native SQL which hibernate can analyze the related tables from the query)?

I appreciate if you can share the experience of Cache and Stored Procedue in Hibernate. Thanks in advance.