Actually I have looked at that.... Sorry no go. Oracle imbeded java does not allow you to call any external c modules. What I mean is if the Remedy Java API were pure java it would work, but since the Java API needs to call the c file (.so on Sun, .dll on Windows) it won't work. You can call external OS programs from inside Oracle so you call a perl or Java program. The drawback is that Oracle will be starting a shell to run the program which takes time.
What I wanted to do was have an Oracle table with a Remedy view form against it. When an external system would insert a record into it, an after insert trigger would call Remedy with the API changing the status of the record from "New" (0) to "Ready to Process" (1) to inform Remedy that the record is there. Filters on the view form fire on 'TR.Status' = "Ready to Process". This way I could have Remedy know about new records without having to wait on the Escalator to process. What I ended up doing was to write a small perl program that queries Oracle (with DBI) for any records where (Status = 0) and uses the Remedy API to do the status change for each. It then sleeps 5 seconds and queries Oracle again. I added it to the armonitor.conf so it starts with the system and if it dies for some reason armonitor restarts it automatically. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, October 06, 2006 12:35 PM To: [email protected] Subject: Re: Perform Push Field from Oracle Gopala Krishna.Peela, Remedy has a Java API. I think you can write "Java code" and embed it into the Oracle server... somehow... (not an Oracle DBA) Assuming you can get that working then your Oracle process could "call" an ARS API client and "pass the data" to ARS that way. Could that meet the need? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Gopala Krishna Peela > Sent: Friday, October 06, 2006 2:28 PM > To: [email protected] > Subject: Perform Push Field from Oracle > > > > Hi, > > > > Can we call push field action (submitting record) from oracle without > using insert sql command. > > Which means this action should be able to fire remedy filter...from oracle.. > > > > Thanks and Regards, > > Gopala Krishna.Peela ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
