SQL_TRANSPILER

SQL_TRANSPILER enables or disables the SQL Transpiler.

Property Description
Parameter type String
Syntax SQL_TRANSPILER = { ON | OFF }
Default value OFF
Modifiable ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB Yes
Basic No
Oracle RAC Different instances can use different values.

When this parameter is set to ON, the SQL Transpiler feature is enabled and PL/SQL functions are automatically transpiled into SQL expressions whenever possible, without user intervention. When this parameter is set to OFF, the SQL Transpiler feature is disabled.

Note: This parameter is available starting with Oracle AI Database 26ai.