RE: Renaming files on Unix via PL/SQL

2002-04-19 Thread MacGregor, Ian A. 

Yes you could,  but one needs to be aware of the security implications.  One hopes 
that nobody is running their external procedure listener under a privileged user such 
as oracle or root.If so who ever could use the  PL/SQL procedure could  rename  
YOU right out of a job.  

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, April 19, 2002 2:09 PM
To: Multiple recipients of list ORACLE-L


Babu,

can you give an example ?

thanks
Santi

-Original Message-
Sent: Friday, April 19, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L


Sorry to get on this thread so late...

To answer Emre's question, we can do it if you have a extproc listener
configured and have a external procedure to do the same.

Babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 8:53 AM


> HOST is a SQL*Plus command only.
>
> --- John Weatherman <[EMAIL PROTECTED]> wrote:
> > What about issueing a HOST command through dbms_sql?  Not saying it
> > will
> > work (I haven't tried it)
> > but it seems like it should.
> >
> > -Original Message-
> > Sent: Friday, April 19, 2002 5:53 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> >
> > no, there's no way to do that through PL/SQL.
> > If have the option of using java you can use the solution given by
> > Tom Kyte
> > at
> >
>
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840
> > 241
> >
>
 > 0241>
> >
> > Regards,
> > Mike Hately
> >
> > -Original Message-
> > Sent: 19 April 2002 10:03
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Hi all,
> > Is it possible to rename files (e.g  .txt files) on Unix by using
> > PL/SQL? Is
> > there a function to do that?
> >
> >
> > Regards
> >
> > M.Emre HANCIOGLU
> > Masterfoods Services GmbH
> > ISI Application Support
> > Tel : +49 2162 500-576
> > Fax: +49 2162 41497
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> >
> >
>

> > 
> >
> >
> > This email and any attached to it are confidential and intended
> > only for the
> > individual or
> >
> > entity to which it is addressed. If you are not the intended
> > recipient,
> > please let us know
> >
> > by telephoning or emailing the sender. You should also delete the
> > email and
> > any attachment
> >
> > from your systems and should not copy the email or any attachment
> > or
> > disclose their content
> >
> > to any other person or entity. The views expressed here are not
> > necessarily
> > those of
> >
> > Churchill Insurance Group plc or its affiliates or subsidiaries.
> > Thank you.
> >
> > Churchill Insurance Group plc. Company Registration Number -
> > 2280426.
> > England.
> >
> > Registered Office: Churchill Court, Westmoreland Road, Bromley,
> > Kent BR1
> > 1DP.
> >
> >
> >
> >
>
>
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Raube
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babu Nagarajan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Prakriteswar Santikary
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY,

RE: Renaming files on Unix via PL/SQL

2002-04-19 Thread Prakriteswar Santikary 

Babu,

can you give an example ?

thanks
Santi

-Original Message-
Sent: Friday, April 19, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L


Sorry to get on this thread so late...

To answer Emre's question, we can do it if you have a extproc listener
configured and have a external procedure to do the same.

Babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 8:53 AM


> HOST is a SQL*Plus command only.
>
> --- John Weatherman <[EMAIL PROTECTED]> wrote:
> > What about issueing a HOST command through dbms_sql?  Not saying it
> > will
> > work (I haven't tried it)
> > but it seems like it should.
> >
> > -Original Message-
> > Sent: Friday, April 19, 2002 5:53 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> >
> > no, there's no way to do that through PL/SQL.
> > If have the option of using java you can use the solution given by
> > Tom Kyte
> > at
> >
>
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840
> > 241
> >
>
 > 0241>
> >
> > Regards,
> > Mike Hately
> >
> > -Original Message-
> > Sent: 19 April 2002 10:03
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Hi all,
> > Is it possible to rename files (e.g  .txt files) on Unix by using
> > PL/SQL? Is
> > there a function to do that?
> >
> >
> > Regards
> >
> > M.Emre HANCIOGLU
> > Masterfoods Services GmbH
> > ISI Application Support
> > Tel : +49 2162 500-576
> > Fax: +49 2162 41497
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> >
> >
>

> > 
> >
> >
> > This email and any attached to it are confidential and intended
> > only for the
> > individual or
> >
> > entity to which it is addressed. If you are not the intended
> > recipient,
> > please let us know
> >
> > by telephoning or emailing the sender. You should also delete the
> > email and
> > any attachment
> >
> > from your systems and should not copy the email or any attachment
> > or
> > disclose their content
> >
> > to any other person or entity. The views expressed here are not
> > necessarily
> > those of
> >
> > Churchill Insurance Group plc or its affiliates or subsidiaries.
> > Thank you.
> >
> > Churchill Insurance Group plc. Company Registration Number -
> > 2280426.
> > England.
> >
> > Registered Office: Churchill Court, Westmoreland Road, Bromley,
> > Kent BR1
> > 1DP.
> >
> >
> >
> >
>
>
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Raube
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babu Nagarajan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Prakriteswar Santikary
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Renaming files on Unix via PL/SQL

2002-04-19 Thread Babu Nagarajan 

Sorry to get on this thread so late...

To answer Emre's question, we can do it if you have a extproc listener
configured and have a external procedure to do the same.

Babu
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 8:53 AM


> HOST is a SQL*Plus command only.
>
> --- John Weatherman <[EMAIL PROTECTED]> wrote:
> > What about issueing a HOST command through dbms_sql?  Not saying it
> > will
> > work (I haven't tried it)
> > but it seems like it should.
> >
> > -Original Message-
> > Sent: Friday, April 19, 2002 5:53 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> >
> > no, there's no way to do that through PL/SQL.
> > If have the option of using java you can use the solution given by
> > Tom Kyte
> > at
> >
>
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840
> > 241
> >
>
 > 0241>
> >
> > Regards,
> > Mike Hately
> >
> > -Original Message-
> > Sent: 19 April 2002 10:03
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Hi all,
> > Is it possible to rename files (e.g  .txt files) on Unix by using
> > PL/SQL? Is
> > there a function to do that?
> >
> >
> > Regards
> >
> > M.Emre HANCIOGLU
> > Masterfoods Services GmbH
> > ISI Application Support
> > Tel : +49 2162 500-576
> > Fax: +49 2162 41497
> > E-Mail: [EMAIL PROTECTED]
> >
> >
> >
> >
>

> > 
> >
> >
> > This email and any attached to it are confidential and intended
> > only for the
> > individual or
> >
> > entity to which it is addressed. If you are not the intended
> > recipient,
> > please let us know
> >
> > by telephoning or emailing the sender. You should also delete the
> > email and
> > any attachment
> >
> > from your systems and should not copy the email or any attachment
> > or
> > disclose their content
> >
> > to any other person or entity. The views expressed here are not
> > necessarily
> > those of
> >
> > Churchill Insurance Group plc or its affiliates or subsidiaries.
> > Thank you.
> >
> > Churchill Insurance Group plc. Company Registration Number -
> > 2280426.
> > England.
> >
> > Registered Office: Churchill Court, Westmoreland Road, Bromley,
> > Kent BR1
> > 1DP.
> >
> >
> >
> >
>
>
> __
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Raube
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babu Nagarajan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Renaming files on Unix via PL/SQL

2002-04-19 Thread Joe Raube 

HOST is a SQL*Plus command only.

--- John Weatherman <[EMAIL PROTECTED]> wrote:
> What about issueing a HOST command through dbms_sql?  Not saying it
> will
> work (I haven't tried it)
> but it seems like it should.
> 
> -Original Message-
> Sent: Friday, April 19, 2002 5:53 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
>  
> no, there's no way to do that through PL/SQL.
> If have the option of using java you can use the solution given by
> Tom Kyte
> at
>
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840
> 241
>
 0241>  
>  
> Regards,
> Mike Hately
> 
> -Original Message-
> Sent: 19 April 2002 10:03
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi all, 
> Is it possible to rename files (e.g  .txt files) on Unix by using
> PL/SQL? Is
> there a function to do that? 
> 
> 
> Regards 
> 
> M.Emre HANCIOGLU
> Masterfoods Services GmbH
> ISI Application Support
> Tel : +49 2162 500-576
> Fax: +49 2162 41497
> E-Mail: [EMAIL PROTECTED]
> 
> 
> 
>

>  
> 
> 
> This email and any attached to it are confidential and intended
> only for the
> individual or 
> 
> entity to which it is addressed. If you are not the intended
> recipient,
> please let us know 
> 
> by telephoning or emailing the sender. You should also delete the
> email and
> any attachment 
> 
> from your systems and should not copy the email or any attachment
> or
> disclose their content 
> 
> to any other person or entity. The views expressed here are not
> necessarily
> those of 
> 
> Churchill Insurance Group plc or its affiliates or subsidiaries.
> Thank you. 
> 
> Churchill Insurance Group plc. Company Registration Number -
> 2280426.
> England. 
> 
> Registered Office: Churchill Court, Westmoreland Road, Bromley,
> Kent BR1
> 1DP. 
> 
> 
> 
> 


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Renaming files on Unix via PL/SQL

2002-04-19 Thread John Weatherman 



What 
about issueing a HOST command through dbms_sql?  Not saying it will work (I 
haven't tried it)
but it 
seems like it should.

  -Original Message-From: Hately Mike 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 5:53 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Renaming files on Unix via PL/SQL
  Hi,
   
  no, 
  there's no way to do that through PL/SQL.
  If 
  have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241 
   
  Regards,
  Mike 
  Hately
  
-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: 19 April 2002 
10:03To: Multiple recipients of list ORACLE-LSubject: 
Renaming files on Unix via PL/SQLHi all, Is it 
possible to rename files (e.g  .txt files) on Unix by using PL/SQL? Is 
there a function to do that? Regards M.Emre 
HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : 
+49 2162 500-576Fax: +49 2162 41497E-Mail: 
[EMAIL PROTECTED]
   
  
  This email and any attached to it are confidential 
  and intended only for the individual or 
  entity to which it is addressed. If you are not the 
  intended recipient, please let us know 
  by telephoning or emailing the sender. You should 
  also delete the email and any attachment 
  from your systems and should not copy the email or 
  any attachment or disclose their content 
  to any other person or entity. The views expressed 
  here are not necessarily those of 
  Churchill Insurance Group plc or its affiliates or 
  subsidiaries. Thank you. 
  Churchill Insurance Group plc. Company Registration 
  Number - 2280426. England. 
  Registered Office: Churchill Court, Westmoreland 
  Road, Bromley, Kent BR1 1DP.

RE: Renaming files on Unix via PL/SQL

2002-04-19 Thread Hately Mike 



Hi,
 
no, 
there's no way to do that through PL/SQL.
If 
have the option of using java you can use the solution given by Tom Kyte at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:952229840241 
 
Regards,
Mike 
Hately

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: 19 April 2002 
  10:03To: Multiple recipients of list ORACLE-LSubject: 
  Renaming files on Unix via PL/SQLHi all, Is it 
  possible to rename files (e.g  .txt files) on Unix by using PL/SQL? Is 
  there a function to do that? Regards M.Emre 
  HANCIOGLUMasterfoods Services GmbHISI Application SupportTel : +49 
  2162 500-576Fax: +49 2162 41497E-Mail: 
  [EMAIL PROTECTED]



  


This email and any attached to it are confidential and intended only for the individual or 

entity to which it is addressed.  If you are not the intended recipient, please let us know 

by telephoning or emailing the sender.  You should also delete the email and any attachment 

from your systems and should not copy the email or any attachment or disclose their content 

to any other person or entity.  The views expressed here are not necessarily those of 

Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 

Churchill Insurance Group plc.  Company Registration Number - 2280426. England. 

Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.

Renaming files on Unix via PL/SQL

2002-04-19 Thread emre . hancioglu 

Hi all,
Is it possible to rename files (e.g  .txt files) on Unix by using PL/SQL? Is there a function to do that?


Regards

M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]