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

Pedro Lopes wrote:
> 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

Can you use utl_smtp to email it to the other machine?

Pedro Lopes wrote:

> 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

Not based on what you posted. Are you being charged by the character to
post here?

What other system?
Running under what operating system?
Receiving the file how?
Have you looked into heterogeneous services?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

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@netvisao.pt> wrote in message
news:newscache$6n5q6i$wh9$1@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

KurtisK wrote:

> 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 ...

Because Sybrans knows of what he speaks and you are apparently unaware
of the functionality of UTL_FILE.

UTL_FILE will gladly write a text file onto the local operating system.
That has nothing to do with what the OP asked: Absolutely nothing!

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

See that:
You can setup a "Directory" to point towards a network share.



"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1099969572.93305@yasure...
> KurtisK wrote:
>
>> 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 ...
>
> Because Sybrans knows of what he speaks and you are apparently unaware
> of the functionality of UTL_FILE.
>
> UTL_FILE will gladly write a text file onto the local operating system.
> That has nothing to do with what the OP asked: Absolutely nothing!
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace 'x' with 'u' to respond)

Pedro Lopes <pedro.lopes@netvisao.pt> wrote in message news:<newscache$6n5q6i$wh9$1@newsfront4.netvisao.p t>...
> 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

Indeed, you point the Directory to a Network Share as Jack mentioned. I am
well aware of how UTL_FILE works. Like I said, you guys are ornary and take
this too seriously. People participate to learn in these forums, not get
chastised with sarcasm.

Kurt

--


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com

"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1099969572.93305@yasure...
> KurtisK wrote:
>
> > 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 ...
>
> Because Sybrans knows of what he speaks and you are apparently unaware
> of the functionality of UTL_FILE.
>
> UTL_FILE will gladly write a text file onto the local operating system.
> That has nothing to do with what the OP asked: Absolutely nothing!
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace 'x' with 'u' to respond)

Jack wrote:

> See that:
> You can setup a "Directory" to point towards a network share.

Network share ... that's a Windows term isn't it?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Am Thu, 11 Nov 2004 20:22:37 -0800 schrieb DA Morgan
<damorgan@x.washington.edu>:

> Jack wrote:
>
>> See that:
>> You can setup a "Directory" to point towards a network share.
>
> Network share ... that's a Windows term isn't it?

But may denote an NFS Mount Point on UNIX systems too.
We already used this approach in LAN or MAN environments.

--
Frank Piron,
etfrankatkonaddotn
(leftrotate two)