Create a web service interface in Remedy, and let Oracle access this using SOAP.
http://www.oracle.com/technology/sample_code/tech/java/jsp/readme.callout.htm -- Jarl On 10/7/06, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:
** No. Oracle will not allow you to call an external c routine (the API's .dll or .so file) from inside a stored procedure. The Remedy Java API requires the c API shared library (.dll or .so) file. Apparently Oracle thought it was a security risk to call a .dll or .so routine and not a risk to shell out and call a program. Our DBA's prevent the shell out method. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Friday, October 06, 2006 1:35 PM To: [email protected] Subject: Re: Perform Push Field from Oracle ** Fred: Could you not do this through a database trigger and a stored procedure? James McKenzie L-3 GSI -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, October 06, 2006 11:20 AM To: [email protected] Subject: Re: Perform Push Field from Oracle 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 __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
