Description
Consider script from attached .zip
gh-8579_-_make-nested-subroutines.sql.zip
Note: database creation / connect must use remote protocol.
On Windows and Linux its output has following tail:
Sub procedure SP_MAIN_SUB_PROC_00017:
Variables:
Number Name
---------------------------------------
0 N
BLR to Source mapping:
BLR offset Line Column
--------------------------------
14 164 1
21 165 1
23 166 1
Sub procedure SP_MAIN_SUB_PROC_00018:
Variables:
Number Name
---------------------------------------
0 N
BLR to Source m
apping:
BLR offset Line Column
--------------------------------
14 169 1
21 170 1
23 171 1
=======================================
(i.e. line "BLR to Source mapping:" is broken for sub_proc00018).
No such problem if we try to use only nested functions (instead of SPs) or just nested procedures (without functions).