I am trying to escape html characters for html generated by pl sql (htp.p)
Here is what I have:
This is OK, but I would like to add in semi colons. Of course, if I don't escape the semi colon first, it starts replacing semi colons in the already escaped sequences - This is the same for the ampersand, which is why it is the first thing escaped. I haven't yet been able to come up with a way to do both without it starting to interfere with previously escaped characters.
Also, if anyone has any suggestion for already existing pl sql API's for this purpose, that would be great too,
I have looked at utl_url.escape - wrong escape format of course - took me too long to realize that ha
and also htf.escape_sc - this does not escape everything I need it to - but if you are familiar with this you will recognize my own function up there
True wisdom is in knowing you know nothing - Socrates