Trying out Domains for LoV I have created a Enum ( a, b, c , …), the simplest domain possible. But when I tried to use the full list of 3999 Roman Numbers, I got errors using Domain_display (tab.col). I suspect the error occurs when the clob_field in user_domains gows over 32K.
Anyone else ran into this ? Is this an intended/documented limitation ?
I would suspect this has been “found” by others before me, but searching didnt reveal anything yet.
Scirpts ….of course I have scrips…
The complete demo, self-running, self-explaining.
Just hit enter 12 times (that is XII times, and some queries a bit slow at 5+ seconds…)
demo_enum.sql:
https://drive.google.com/file/d/1Wlg5zkegyosblrIFBvuDY25v0Di7K9xo/view?usp=sharing
Or use this script with a non-error, working domain, and edit out the two lines at line 4102 to re-cause the error:
demo_enum_2size.sql:
https://drive.google.com/file/d/1NBNYBZ4_e3Y2zcend7wDWoUTMpJtEh3w/view?usp=sharing