2.384 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.