My Oracle Support Banner

How To Use a Stored Procedure To Update The DB And Maintain The TopLink Cache (Doc ID 233435.1)

Last updated on DECEMBER 19, 2019

Applies to:

Oracle TopLink - Version and later
Information in this document applies to any platform.


TopLink supports generating SQL for all database operations and
provides an expression framework that supports defining simple and
complex queries at the object level. Occasionally, your application
may require a very complex update queries using custom SQL, or the use
of a stored procedure on the database. If this is the case, TopLink
also allows database operations to be customized through SQL or stored
procedure calls.

When you use custom SQL or a stored procedure to insert, delete or
update a record in the database, TopLink is not aware of these changes
and therefore cannot maintain correct data in the TopLink cache


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.