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