Faced similar issue and can understand situation
Vikash Kumar Sharma, October 01, 2020 - 10:59 am UTC
Table is to be passed as input to the store proc, so before defining proc, I have declared table type in proc.
But as table input to proc is variable, so table type declared in package should be dynamic too because every time when proc is called there can be different table type or structure.
That is the necessity to have dynamic table type here.
October 01, 2020 - 12:15 pm UTC
How exactly are you using this table type?