Running a query manually when using web modules

From: none <none_at_none.com>
Date: Tue, 13 Apr 2004 16:35:06 GMT
Message-ID: <f417bd5e24720a912e0e0d78d3ffc487@news.teranews.com>

Hi. I'm implementing a web deployment using 9i. I have a table for STOCK, which has one or more PURCHASES, which have one or more PURCHASE_ITEMS.

When a purchase item is INSERTED, I'd like the web module component to update the relevant grandparent record of STOCK, and when UPDATED, to remember the previous level and adjust accordingly.

I'm sure that this can probably be done in PL/SQL, but don't have a clue how - all books and tutorials I have found take a 'PHP-style' approach or use servlets and don't seem to use web modules.

I am mostly familiar with Design Editor. Can anyone help? Thanks. Received on Tue Apr 13 2004 - 11:35:06 CDT