[Openroad-users] OpenROAD and Oracle

[stephen.mcculloch at falkirk.gov.uk]

Hi Peter

We have a Payroll Application(oracle) and a Pension 
Application(ingres/openroad)

We hold fields, Employee number, Post id and Pensions number on 
both systems. These fields are predominantly administered from the 
Payroll application. When a change has been made to any of the 
fields by payroll staff an internal memo is sent to Pensions informing 
them of the change. I was looking to update the Pensions application 
automatically when a change has occurred.



 
On 21 Dec 2006 at 7:04, Peter van Bennekom wrote:

> Hi Stephen,
> 
> As far as I know without writing your own API's to another DLL that
> wraps Oracle database access to bypass the gateway, it is not
> possible.
> 
> What are you trying to accomplish?
> 
> Peter
> 
> Peter van Bennekom | Senior Technical Architect | Infor | office: +1
> (610) 407-8113 | fax: +1 (610) 407-8027
> 
> -----Original Message-----
> From: openroad-users-bounces at peerlessit.com
> [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
> stephen.mcculloch at falkirk.gov.uk
> Sent: Thursday, December 21, 2006 8:43 AM
> To: OpenROAD Users
> Subject: [Openroad-users] OpenROAD and Oracle
> 
> Hi all
> 
> Is it possible to query an Oracle table from within OpenROAD 
> without using Enterprise Access for Oracle?
> 
> Thanks
> 
> Stephen
> 
> Stephen B McCulloch
> Software Developer
> ----------------------------
> Corporate & Commercial Services
> ICT Infrastructure (Software Development)
> Falkirk Council,
> Municipal Buildings,
> West Bridge Street,
> Falkirk, FK1 5RS
> Scotland, UK
> ------------------------------------------
> Telephone : (01324) 501523
> Fax          : (01324) 501516
> E-mail      : stephen.mcculloch at falkirk.gov.uk
> 
> 
> **********************************************************************
> ** ** The information contained in this e-mail is confidential and is
> intended only for the named recipient(s). If you are not the intended
> recipient, you must not copy, distribute or take any action or
> reliance on it. If you have received this e-mail in error, please
> notify the sender. Any unauthorised disclosure of the information
> contained in this e-mail is strictly prohibited.
> 
> The views and opinions expressed in this e-mail are the senders own
> and do not necessarily represent the views and opinions of Falkirk
> Council.
> **********************************************************************
> ** **
> 
> _______________________________________________
> Openroad-users mailing list  Openroad-users at peerlessit.com
> 
> To unsubscribe please click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
> 
> To subscribe please click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe 
> 
> _______________________________________________
> Openroad-users mailing list  Openroad-users at peerlessit.com
> 
> To unsubscribe please click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
> 
> To subscribe please click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe 



**************************************************************************
The information contained in this e-mail is confidential and is intended only for the named recipient(s). If you are not the intended recipient, you must not copy, distribute or take any action or reliance on it. If you have received this e-mail in error, please notify the sender. Any unauthorised disclosure of the information contained in this e-mail is strictly prohibited.

The views and opinions expressed in this e-mail are the senders own and do not necessarily represent the views and opinions of Falkirk Council.
**************************************************************************