Stored procedures with hibernate

In an earlier post i wrote up an article explaining how to call stored procedures using Spring's StoredProcedureCall template. This i believe is a very clean solution to handle all stored procedure related details. But this article is for those who already use the hibernate template and want to get things done using that without going into much details of using the Spring's StoredProcedureCall.

So i will guide you step by step on how to achieve this.
Following is a sample stored procedure. Note that this is not a complete proc, but just an extract.

create or replace PROCEDURE         MYSYS_P_MY_TEST_PROC
   (
       p_recordset      OUT SYS_REFCURSOR,
       p_airport_iata_id IN varchar2  ,
       p_flight_number   IN varchar2  ,
       p_flight_dep_date IN varchar2  
   )

Read more: My Journey Through IT

Posted via email from .NET Info