2.380 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 Database 23ai.