Re: Perform Push Field from Oracle
Jarl, Exactly what my next thought was, WebServices. :) Or if your developers would prefer you might be able to do an RMI based solution too. (It looks like Oracle supports that model.) However that would likely be more "work" then using a WebService interface. I find it very strange that JNI can be "disabled" in a compliant JVM. I guess their is a way to do that, and Oracle is doing it. Which is news to me. :) -- 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/7/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote: 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 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Perform Push Field from Oracle
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG > 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
Re: Perform Push Field from Oracle
Title: RE: Perform Push Field from Oracle ** 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/L3Sent: Friday, October 06, 2006 1:35 PMTo: arslist@ARSLIST.ORGSubject: 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:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, October 06, 2006 11:20 AM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Carey Matthew Black Sent: Friday, October 06, 2006 12:35 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Gopala Krishna Peela > Sent: Friday, October 06, 2006 2:28 PM > To: arslist@ARSLIST.ORG > 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___
Re: Perform Push Field from Oracle
Title: 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:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, October 06, 2006 11:20 AM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Carey Matthew Black Sent: Friday, October 06, 2006 12:35 PM To: arslist@ARSLIST.ORG 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:arslist@ARSLIST.ORG] On Behalf Of Gopala Krishna Peela > Sent: Friday, October 06, 2006 2:28 PM > To: arslist@ARSLIST.ORG > 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 __20060125___This posting was submitted with HTML in it___
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG > 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
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: arslist@ARSLIST.ORG 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
Re: Perform Push Field from Oracle
** My requirement is execute the procedure from oracle..and that procedure should be able to fire remedy filter.. Thanks and Regards, Gopala Krishna.Peela From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanjeev_Gurram Sent: Friday, October 06, 2006 2:43 PM To: arslist@ARSLIST.ORG Subject: Re: Perform Push Field from Oracle Can u write the store producers and call the store producers using set fields 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: arslist@ARSLIST.ORG 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 DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Perform Push Field from Oracle
** Can u write the store producers and call the store producers using set fields 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: arslist@ARSLIST.ORG 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 DISCLAIMER:This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
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___