Gopala, A filter "Submit" event is not the same as an SQL insert. They are logically similar, but very different. All Filter processing is done by the Application server and all SQL processing is done by the RDBMS.
It is a common mistake for a DBA to think that filters should be triggered by RDBMS activity. They are at different layers in the architecture and are very independent of each other. (by design) You have to talk to the application server (via the Supplied API, or other such interface) to trigger any "Filter" processing directly. On the other hand.... If this table can be dealt with as a queue and batch processing is acceptable to your business process, then you could use an Escalation to poll the view form and trigger filters in a batch processing design too. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 10/9/06, Gopala Krishna Peela <[EMAIL PROTECTED]> wrote:
** Hi, I want to inert a record into a table from oracle using insert command. So I have created filter on view form of above table which should execute on submit. But it is not recognizing submit action from oracle. Is there any way to trigger remedy action from oracle... I should not use any escalation..(this is requirement dependency) Thanks and Regards, Gopala Krishna.Peela
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
