Re: Questions on External Procedure

From: Shelby Cain <vhorrit_at_n-o-s-p-a-m.hotmail.com>
Date: Tue, 10 Oct 2000 01:32:12 GMT
Message-ID: <wkuE5.49631$3y3.955994@typhoon.austin.rr.com>

I've seen Oracle 8i java stored procedures accessing Portal's billing engine using its native API. Of course the java permissions needed to be correctly tweaked to allow the code to open TCP/IP sockets to other machines. Since that worked, I would theorize you can do just about anything you want with external stored procedures.

Sorry I can't give you more in depth details.. I wasn't heavily involved with the development of the project...

Regards,

Shelby Cain

<akkha_at_my-deja.com> wrote in message news:8rtf2d$nao$1_at_nnrp1.deja.com...
> Hi,
>
> I have done some studies on using external procedure. It seems to be very
> useful for my purposes. But I have one concern. Is it possible to call an
> external procedure (C or Java) to access another system. I am referring to
a
> truly distributed system, with Oracle Server running on one machine and
may
> be some other services (file system for example) on another machine. Could
> external procedure handles the scenario?
>
> Anthony
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 09 2000 - 20:32:12 CDT