I have the code below that works fine in Oracle 11, when loaded into Oracle 19 I get Ora-01744 and not sure why? and/or what I need to change to make it work.
Type Letter_Flds Is Record(Letter Varchar2(3));
Type Tab_Letters Is Table Of Letter_Flds;
Rec_Letters Tab_Letters := Tab_Letters();
Procedure Generate_Excel_Letters
Is
Begin
With letters
As (Select chr( ascii('A')+level-1 ) letter
Bulk Collect Into Rec_Letters
From dual
Connect By Level <= 26)
Select * From letters
Union All
Select l1.letter || l2.letter
From letters l1, letters l2
End Generate_Excel_Letters;