Re: Send file to other filesystem using PLSQL

Yes, you can transfer a file from PL/SQL. I don't know why these guys in the Oracle newsgroup get so ornary. I think that Sybrand guy's attitude is wearing off on them.

Use the UTL_FILE package. You can setup a "Directory" to point towards a network share.

i.e.

vcLocation := "SomeDirectoryName"
fh := UTL_File.FOPEN(vcLocation, vcFileName, 'W', biMaxLineSize);

etc ..

etc ...

-- 


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.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