Re: Trigger Remedy Action from Oracle

2006-10-09 Thread Carey Matthew Black

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


Re: Trigger Remedy Action from Oracle

2006-10-09 Thread Michiel Beijen

Hi Gopala Krishna.Peela

This is the third time you have posted an issue about this on the
ARSList in a weeks time.
Do you think this helps?
People have already suggested the use of Remedy Webservices.
It might be best that you try to reply to earlier mails regarding the
same subject, or at least reference these earlier posts.
--
Michiel

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





__20060125___This posting was submitted with HTML 
in it___


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


Trigger Remedy Action from Oracle

2006-10-09 Thread Gopala Krishna Peela
**








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

 

 

 






__20060125___This posting was submitted with HTML in it___