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___
