dynamic sql from Forms

I'd like to store some SQL in the database and call it from a form. If I store the name of a sql script in the database, I can call the script with a host('sqlplus / _at_scriptname'); command, but I want this SQL script to be able to do some complicated validation of multiple rows of parameter data being inserted/updated from the form.

Even if I call the script from the post-commit trigger, the changes to the data are not apparent to the script. I assume that this is because the host command actually starts a sub-process, and the sub-process can't see the pending changes to the database.

Is there a way around this? (Short of committing the data, checking it, and then telling the user that they need to make further changes after it's already been committed.)

Jennifer R. Amon            PHONE: (216) 775-6987
Houck Computing Center        FAX: (216) 775-8573
Oberlin College
Oberlin, OH 44074        INTERNET: bamon_at_ocvaxc.cc.oberlin.edu


_____________________________________________________________________