SQLcl: SET PARAMETERPOLICY

set parameterpolicy [share | isolate]

The default value of parameterpolicy is share. In this mode, arguments (but not variables!) are global.

By setting the value to isolate, an SQL script creates a private copy of the values of the arguments. This copy is discarded when the script exits.