Re: Reading a file on Windows from a trigger in an Oracle database

From: h <h_at_H.com>
Date: Sat, 04 Oct 2003 05:27:12 -0400
Message-ID: <Amwfb.8786$N94.6509@lakeread02>

Because the file resides on the intel box and i need to read it from a trigger on a database which is on a unix box. let me confess that i ma yet to read up on external table option but with the limited info i hv, i think it is not possible.

right now, i am trying to see if i can use utl_http instead of samba.

thanks,

Sybrand Bakker wrote:
> On Thu, 02 Oct 2003 05:37:28 -0400, h <h_at_h.com> wrote:
>
>

>>Thanks for the suggestion. But the main problem is that the file needs 
>>to be read from a trigger. So i think the external table option is of 
>>limited use here.

>
>
> Why do you think so? You can select from external tables just as
> ordinary tables.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Oct 04 2003 - 04:27:12 CDT