Skip Headers

# Using SQL Calls

Previous

Next

The TopLink expression framework enables you to define complex queries at the object level. If your application requires a more complex query or one that accesses data or stored procedures directly, you can specify a custom SQL string in an SQL `Call` object and provide that `Call` object to any query.

You can also specify an SQL string directly on `DatabaseQuery`. For more information, see "Specifying a Custom SQL String in a DatabaseQuery".

When using SQL calls, you can use a `ReturningPolicy` to control whether or not TopLink writes a parameter out or retrieves a value generated by the database. For more information, see "Configuring Returning Policy".

This section describes the following:

- Using an SQLCall

- Using a StoredProcedureCall

- Using a StoredFunctionCall