We thought however with the complexity of the user data, having to translate their data to valid database data, combine existing input and database data to form new database data and being be able to create descriptive edit reports of the load, perl had a little more flexibility than sql loader.
You might be best off using Perl to process your user input but replacing your insert statements with prints to an output file that can subsequently be processed by the SQL loader. | [reply] |
That's an interesting idea, I'll give that a look into.
Thank you.
| [reply] |