Calling database stored procedures using EJB

[panchalee phookan]

Hi
Can one call database stored procedures using EJBs? Is it also possible to handle REF CURSORs using EJB?
regards
panchalee

[Raja Shekhar]

YES Ucan
..USe PREPARE CALL
Raj

[Avinash Naimpally]

Yes you can use stored procedures in an EJB.
But I personally dont feel it is advisible to use any database specific or application specific code in your EJB. This woul;d prevent your EJB from being portable across different databases or across different application servers (incase either of them changes tomorrow).
However I am a novice to EJBs. I maybe wrong. Pls recheck on this.
Regards,
Avinash