Data interchange between databases

From: Frugal Sam <frugalsam_at_hotmail.com>
Date: Wed, 12 Jun 2002 03:59:44 GMT
Message-ID: <Xns922AD5AEAAEEAfrugalsamhotmailcom@204.127.36.1>

Hello

I am in the process of designing a database to hold the hierarchy of our finance organization.

Other applications would like to access this data; I would like to expose a few APIs these applications could call to access the necessary data. The data being returned is almost insignificant in size - about 2 - 3 records of a couple of hundred bytes each.

I do not want these applications to directly access tables or views in "my" schema. I would like them to send me a "call" and I would like to respond by supplying them the data they need.

What are some ways of accomplishing this ?

Thanks. Received on Tue Jun 11 2002 - 22:59:44 CDT