Return
-
Title
Script, Execute package generated code has changed -
Description
The execute package option in the schema browser ignores variables with a default value. This is not expected, nor is it desired behavior.Execute package generated code has changed from TFO 12.6 to 12.8 & 12.9 -
Cause
This is by design
The reason is in prior versions, it would put the default in the anonymous block as referenced above. -
Resolution
Toad actually stored that value, so the next time you went in, then it would display that default value again.
But, in reality, that default value could actually be changed, and then if you used Toad, then it would be defaulting the old value instead of the new one. This way is actually better because it prevents an issue if someone changes the default value.Another point is that the default value is not needed in the anonymous block. It will run without that variable because it's a default value.It was seen copying that anonymous block and run it somewhere else, but even then it's not needed.But if one really want it there, then one can change the "Input Type" to Default/Literal and that will put it back in there.