DEFAULT PARAMETERS
This article is about the current transformation of the default parameters and how their functionality is being emulated.
Some parts in the output code are omitted for clarity reasons.
Description
A default parameter is a parameter that has a value in case an argument is not passed in the procedure or function call. Since Snowflake doesn't support default parameters, SnowConvert inserts the default value in the procedure or function call.
In the declaration, the DEFAULT VALUE clause of the parameter is removed. Both syntaxes, the :=
symbol and the DEFAULT
clause, are supported.
Sample Source Patterns
Sample auxiliary code
Default parameter declaration
Oracle
IN -> Oracle_01.sql
Snowflake Scripting
OUT -> Oracle_01.sql
Calling procedures with default parameters
Oracle
IN -> Oracle_02.sql