Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are stored procedures and triggers supported?

April 26, 2017procedures stored supported triggers

0

Posted

Are stored procedures and triggers supported?

1 Answer

0

Posted

EclipseLink has extended support for stored procedures and triggers. Stored procedures are support through the @NamedStoredProcedureQuery, StoredProcedureCall, StoredFunctionCall and PLSQLStoredProcedureCall classes. The following stored procedures features are supported: • IN parameters • OUT parameter • INOUT parameters • result sets • CURSOR OUT parameters • Object-relational datatypes (Struct, Array) • Oracle PLSQL types such as TABLE, RECORD, BOOLEAN • Using a stored procedure in a named query • Using a stored procedure in a dynamic query • Using a stored procedure to override an Entity’s persist, update, remove or find query. • Using a stored procedure to override a mapping’s select, insert or delete query. • Stored functions • Oracle, SQL Server, MySQL, Sybase, DB2, other stored procedure capable platforms Triggers can be used in the tables being processed by EclipseLink. If a trigger is updating data required back in the application, or the id, the @ReturnInsert, @ReturnUpdate