Re: Send file to other filesystem using PLSQL

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 9 Nov 2004 04:43:15 -0800
Message-ID: <92eeeff0.0411090443.ba228ba@posting.google.com>

Pedro Lopes <pedro.lopes_at_netvisao.pt> wrote in message news:<newscache$6n5q6i$wh9$1_at_newsfront4.netvisao.pt>...
> Hi,
> is it possible to send a file to other file system using plsql ?
>
> The objective will be to send a xml file (generated with plsql) to other
> database (not oracle) on other machine.
>
>
> system:
> Oracle9i on windows.
>
>
> thanks,
> PLopes

If you cannot do it in SQL then do it in PL/SQL. If you cannot do it in PL/SQL then do it in Java.

If you have JServer installed then utl_file like file operation from within Oracle is pretty trivial using java.io api. You can read/write/copy/move/delete/rename files.

Regards
/Rauf Received on Tue Nov 09 2004 - 06:43:15 CST