Re: storedProc question

Sameer,

Read Oracle manuals on external stored procedures.
>From external stored procedures you can execute OS commands.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, February 06, 2002 3:20 AM

> Sameer,
>
> What op system are you running with? There is a utility that was posted a
> few days ago by me that allows you to run any os command from pl/sql as
well
> as sqlplus. I'll try and find the original email I sent out.
>
> Cheers,
> Kev.
> "my computer beat me at chess but i won when it came to kick boxing."
> __________________
>
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
>
>
>
>
> -----Original Message-----
> Sent: 06 February 2002 03:30
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all,
> Is there anyway that i can issue OS related command
> e.g. rename a file from storedProc.
> i know is sounds weird, but can we do it.
> (not HOST command which is specific to sqlplus)
>
> any help is appreciated
> thx
> sameer
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ghadge,Sameer
> INET: Sameer_Ghadge_at_Syntelinc.com
>
> 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: ListGuru_at_fatcity.com (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: Thomas, Kevin
> INET: Kevin.Thomas_at_calanais.com
>
> 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: ListGuru_at_fatcity.com (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: Igor Neyman
  INET: ineyman_at_perceptron.com

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: ListGuru_at_fatcity.com (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).