Making Perl code from a TextArea insertable in a table
Greetings to all,
I am looking for directions on making Perl code insertable to a table from a TextArea using auto-generated DML. In doing an analysis of a Perl based web app, it is desired to put the Perl code into a VARCHAR2 or CLOB column in a table. First question, is there a tool designed for doing this? Second question, if I have to build my own tool, where do I use it to condition the TextArea value to an insertable string?
My initial thoughts were 1) In a process called before validations and on submit, examine the TextArea value then apply the tool if needed; or 2) In a process before validations and on submit, apply the tool; or 3) Apply the tool during a validation call (giving the validation a side effect).
This is a specific case of the general problem of allowing the user to put in any characters to a VARCHAR2 TextArea. So if there is a tool that does that conditioning please make me aware of it.
Please share your ideas with me. It could be that I am missing an obvious solution! :)
Regards,
Bill