FAQ
hi all,

I want to run os command from pl/sql block but don know how to do that. My
objective is to put database name,host name,os with version on the top of
the report which i used to send using pl/sql block using utl_smtp package.

any suggestion would really helpful..

--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.

to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

  • Alex Gorbachev at Feb 1, 2006 at 6:46 am
    Oh, come on! It's a google question. Try searching "os command from
    pl/sql" - much faster response.

    Alex

    2006/2/1, Onkar N Tiwary :
    any suggestion would really helpful..
  • David Sharples at Feb 1, 2006 at 9:29 am
    and you can get all of those things from the dataabse itself anyway

    On 2/1/06, Alex Gorbachev wrote:

    >
    Oh, come on! It's a google question. Try searching "os command from
    pl/sql" - much faster response.
    --
    http://www.freelists.org/webpage/oracle-l
  • Onkar N Tiwary at Feb 1, 2006 at 9:58 am
    thanx all of u. I just wanted to know that only as David said i can get all
    of them from the db only but from db i can get the database name,host name
    but don know where to / how to find the os on which the db is running. If u
    can guide me then i will be thankful.
    On 2/1/06, David Sharples wrote:

    and you can get all of those things from the dataabse itself anyway
    On 2/1/06, Alex Gorbachev wrote:

    Oh, come on! It's a google question. Try searching "os command from
    pl/sql" - much faster response.
    --
    Thanks & Regards,
    T. Onkar Nath
    OneAPPS Enterprise Technology Pvt. Ltd.
    to_onkar_at_yahoo.com
    onkarnath.tiwary_at_gmail.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Ken Naim at Feb 1, 2006 at 6:51 am
    what version of oracle are you on?

    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Onkar N Tiwary
    Sent: Wednesday, February 01, 2006 12:22 AM
    To: ORACLE-L
    Subject: running os command from pl/sql block

    hi all,


    I want to run os command from pl/sql block but don know how to do that. My
    objective is to put database name,host name,os with version on the top of
    the report which i used to send using pl/sql block using utl_smtp package.


    any suggestion would really helpful..

    --
    Thanks & Regards,
    T. Onkar Nath
    OneAPPS Enterprise Technology Pvt. Ltd.

    to_onkar_at_yahoo.com
    onkarnath.tiwary_at_gmail.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Onkar N Tiwary at Feb 1, 2006 at 7:45 am
    oracle 9i rel2(9.2.0.6.0)
    On 2/1/06, Ken Naim wrote:

    what version of oracle are you on?

    ------------------------------
    *From:* oracle-l-bounce_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *Onkar N Tiwary
    *Sent:* Wednesday, February 01, 2006 12:22 AM
    *To:* ORACLE-L
    *Subject:* running os command from pl/sql block


    hi all,

    I want to run os command from pl/sql block but don know how to do that. My
    objective is to put database name,host name,os with version on the top of
    the report which i used to send using pl/sql block using utl_smtp package.

    any suggestion would really helpful..

    --
    Thanks & Regards,
    T. Onkar Nath
    OneAPPS Enterprise Technology Pvt. Ltd.
    to_onkar_at_yahoo.com
    onkarnath.tiwary_at_gmail.com
    --
    Thanks & Regards,
    T. Onkar Nath
    OneAPPS Enterprise Technology Pvt. Ltd.
    to_onkar_at_yahoo.com
    onkarnath.tiwary_at_gmail.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Stephane Faroult at Feb 1, 2006 at 10:45 am
    Onkar,

    The only place I know where you can get the OS is V$VERSION, where
    banner like 'TNS%'. Unfortunately, you won't get the exact version, but
    it can be enough if all you want is differentiate Windows from various
    Unix flavours.

    HTH

    Stephane Faroult

    Onkar N Tiwary wrote:
    thanx all of u. I just wanted to know that only as David said i can
    get all of them from the db only but from db i can get the database
    name,host name but don know where to / how to find the os on which the
    db is running. If u can guide me then i will be thankful.


    On 2/1/06, *David Sharples*
    wrote:
    and you can get all of those things from the dataabse itself anyway


    On 2/1/06, *Alex Gorbachev*
    wrote:
    Oh, come on! It's a google question. Try searching "os command
    from
    pl/sql" - much faster response.




    --
    Thanks & Regards,
    T. Onkar Nath
    OneAPPS Enterprise Technology Pvt. Ltd.
    to_onkar_at_yahoo.com
    onkarnath.tiwary_at_gmail.com
    --
    http://www.freelists.org/webpage/oracle-l
  • David Sharples at Feb 1, 2006 at 10:41 am
    SQL> select dbms_utility.port_string from dual;

    PORT_STRING

    Linuxi386/Linux-2.0.34-8.1.0
    On 2/1/06, Stephane Faroult wrote:

    The only place I know where you can get the OS is V$VERSION, where
    banner like 'TNS%'. Unfortunately, you won't get the exact version, but
    it can be enough if all you want is differentiate Windows from various
    Unix flavours.
    --
    http://www.freelists.org/webpage/oracle-l
  • Stephane Faroult at Feb 1, 2006 at 11:07 am

    David Sharples wrote:

    SQL> select dbms_utility.port_string from dual;

    PORT_STRING
    --------------------------------------------------------------------------------
    Linuxi386/Linux-2.0.34-8.1.0



    On 2/1/06, *Stephane Faroult*
    wrote:
    The only place I know where you can get the OS is V$VERSION, where
    banner like 'TNS%'. Unfortunately, you won't get the exact
    version, but
    it can be enough if all you want is differentiate Windows from various
    Unix flavours.
    Good one. I learned something new today.

    Stéphane Faroult
  • David Sharples at Feb 1, 2006 at 11:05 am
    slight warning

    Some OS'es will appear kinda weird, would then have to use some sort of
    decode to make it more readable

    e.g.

    XP Prof
    SQL> select dbms_utility.port_string from dual;

    PORT_STRING

    IBMPC/WIN_NT-8.1.0

    Its not an IBM either, its a dell :-)

    SQL> select decode(dbms_utility.port_string, 'IBMPC/WIN_NT-8.1.0','Windows
    XP Professional') from dual;

    DECODE(DBMS_UTILITY.POR

    Windows XP Professional
    On 2/1/06, Stephane Faroult wrote:


    Good one. I learned something new today.

    --
    http://www.freelists.org/webpage/oracle-l
  • Bobak, Mark at Feb 1, 2006 at 12:42 pm
    Yeah, my Solaris 9 looks a bit odd as well.....


    devora2_(dvl1)$sqlplus mbobak_at_dvl1


    SQL*Plus: Release 9.2.0.7.0 - Production on Wed Feb 1 07:41:03 2006


    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Enter password:


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
    With the Partitioning and OLAP options
    JServer Release 9.2.0.7.0 - Production


    SQL> select dbms_utility.port_string from dual;


    PORT_STRING

    SVR4-be-64bit-8.1.0


    SQL> !uname -a
    SunOS devora2 5.9 Generic_118558-14 sun4u sparc SUNW,Ultra-80



    --
    Mark J. Bobak
    Senior Oracle Architect
    ProQuest Information & Learning

    "There are 10 types of people in the world: Those who understand
    binary, and those who don't."

    ________________________________

    From: oracle-l-bounce_at_freelists.org
    On Behalf Of David Sharples
    Sent: Wednesday, February 01, 2006 6:05 AM
    To: Stephane Faroult
    Cc: onkarnath.tiwary_at_gmail.com; gorbyx_at_gmail.com; ORACLE-L
    Subject: Re: running os command from pl/sql block

    slight warning

    Some OS'es will appear kinda weird, would then have to use some sort of
    decode to make it more readable

    e.g.

    XP Prof
    SQL> select dbms_utility.port_string from dual;

    PORT_STRING
    ---------------------------------------------------------

    IBMPC/WIN_NT-8.1.0

    Its not an IBM either, its a dell :-)

    SQL> select decode(dbms_utility.port_string,
    'IBMPC/WIN_NT-8.1.0','Windows XP Professional') from dual;

    DECODE(DBMS_UTILITY.POR
    -----------------------
    Windows XP Professional

    On 2/1/06, Stephane Faroult wrote:

    Good one. I learned something new today.

    --
    http://www.freelists.org/webpage/oracle-l
  • Mladen Gogala at Feb 1, 2006 at 12:53 pm
    When everybody is publishing port string, let me join the fray:

    SQL> select dbms_utility.port_string from dual;

    PORT_STRING

    Linuxi386/Linux-2.0.34-8.1.0

    SQL>

    It doesn't even say "IBMPC".
  • johan Eriksson at Feb 1, 2006 at 12:59 pm
    and that seems to be the same on all linux distribution

    /johan
    On Wed, 2006-02-01 at 07:53 -0500, Mladen Gogala wrote:

    PORT_STRING
    --------------------------------------------------------------------------------
    Linuxi386/Linux-2.0.34-8.1.0
    --
    http://www.freelists.org/webpage/oracle-l
  • Onkar N Tiwary at Feb 1, 2006 at 12:59 pm
    thanx a lot everyone. now my proc is running fine with the information i was
    thinking of.
    On 2/1/06, Bobak, Mark wrote:

    Yeah, my Solaris 9 looks a bit odd as well.....

    devora2_(dvl1)$sqlplus mbobak_at_dvl1

    SQL*Plus: Release 9.2.0.7.0 - Production on Wed Feb 1 07:41:03 2006

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter password:

    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
    With the Partitioning and OLAP options
    JServer Release 9.2.0.7.0 - Production

    SQL> select dbms_utility.port_string from dual;

    PORT_STRING
    --------------------------------------------------------------------------------
    SVR4-be-64bit-8.1.0

    SQL> !uname -a
    SunOS devora2 5.9 Generic_118558-14 sun4u sparc SUNW,Ultra-80


    *--*
    *Mark J. Bobak*
    *Senior Oracle Architect*
    *ProQuest Information & Learning*

    "There are 10 types of people in the world: Those who understand binary,
    and those who don't."


    ------------------------------
    *From:* oracle-l-bounce_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *David Sharples
    *Sent:* Wednesday, February 01, 2006 6:05 AM
    *To:* Stephane Faroult
    *Cc:* onkarnath.tiwary_at_gmail.com; gorbyx_at_gmail.com; ORACLE-L
    *Subject:* Re: running os command from pl/sql block


    slight warning

    Some OS'es will appear kinda weird, would then have to use some sort of
    decode to make it more readable

    e.g.

    XP Prof
    SQL> select dbms_utility.port_string from dual;

    PORT_STRING
    ---------------------------------------------------------

    IBMPC/WIN_NT-8.1.0
    Its not an IBM either, its a dell :-)

    SQL> select decode(dbms_utility.port_string, 'IBMPC/WIN_NT-8.1.0','Windows
    XP Professional') from dual;

    DECODE(DBMS_UTILITY.POR
    -----------------------
    Windows XP Professional
    On 2/1/06, Stephane Faroult wrote:


    Good one. I learned something new today.

    --
    Thanks & Regards,
    T. Onkar Nath
    OneAPPS Enterprise Technology Pvt. Ltd.
    to_onkar_at_yahoo.com
    onkarnath.tiwary_at_gmail.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Bobak, Mark at Feb 1, 2006 at 12:59 pm
    Notice also, that so far, every string ends in '-8.1.0'. Wonder what
    that's all about?

    --
    Mark J. Bobak
    Senior Oracle Architect
    ProQuest Information & Learning

    "There are 10 types of people in the world: Those who understand
    binary, and those who don't."

    -----Original Message-----
    From: johan Eriksson
    Sent: Wednesday, February 01, 2006 7:59 AM
    To: gogala_at_sbcglobal.net
    Cc: Bobak, Mark; davidsharples_at_gmail.com; Stephane Faroult;
    onkarnath.tiwary_at_gmail.com; gorbyx_at_gmail.com; ORACLE-L
    Subject: Re: running os command from pl/sql block

    and that seems to be the same on all linux distribution

    /johan
    On Wed, 2006-02-01 at 07:53 -0500, Mladen Gogala wrote:

    PORT_STRING
    ----------------------------------------------------------------------
    ----------
    Linuxi386/Linux-2.0.34-8.1.0
    --
    http://www.freelists.org/webpage/oracle-l
  • Foelz.Frank at Feb 1, 2006 at 1:04 pm
    so what is the "8.1.0" which is unique in each OS string ?

    Linuxi386/Linux-2.0.34-8.1.0
    SVR4-be-64bit-8.1.0
    IBMPC/WIN_NT-8.1.0
    Frank
    -----Original Message-----
    From: Mladen Gogala
    Sent: Wednesday, February 01, 2006 1:54 PM
    To: Mark.Bobak_at_il.proquest.com
    Cc: davidsharples_at_gmail.com; Stephane Faroult; onkarnath.tiwary_at_gmail.com;
    gorbyx_at_gmail.com; ORACLE-L
    Subject: Re: running os command from pl/sql block

    When everybody is publishing port string, let me join the fray:

    SQL> select dbms_utility.port_string from dual;

    PORT_STRING

    Linuxi386/Linux-2.0.34-8.1.0

    SQL>

    It doesn't even say "IBMPC".

    --
    Mladen Gogala
    http://www.mgogala.com

    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • johan Eriksson at Feb 1, 2006 at 1:26 pm
    i think it is the version of the two task protocol, but not sure about
    this.

    /Johan
    On Wed, 2006-02-01 at 14:04 +0100, Foelz.Frank wrote:
    so what is the "8.1.0" which is unique in each OS string ?
    --
    http://www.freelists.org/webpage/oracle-l
  • Carel-Jan Engel at Feb 1, 2006 at 1:49 pm
    My $0.02:

    ease_at_admin:/home/oracle>sqlplus system

    SQL*Plus: Release 3.1.3.7.1 - Production on Wed Feb 1 14:39:58 2006

    Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

    Enter password:

    Connected to:
    Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and Parallel Server options
    PL/SQL Release 2.1.6.2.0 - Production

    SQL> select dbms_utility.port_string from dual;
    select dbms_utility.port_string from dual

    *
    ERROR at line 1:
    ORA-06571: Function PORT_STRING does not guarantee not to update database

    SQL> set serveroutput on
    SQL> declare
    2 result varchar2(80);
    3 begin
    4 result := dbms_utility.port_string;
    5 dbms_output.put_line(result);
    6 end;
    7 /
    SystemV/386-3.2-7.0.0

    PL/SQL procedure successfully completed.

    SQL> exit
    Disconnected from Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and Parallel Server options
    PL/SQL Release 2.1.6.2.0 - Production
    ease_at_admin:/home/oracle>uname -a
    SCO_SV admin 3.2 2 i386
    ease_at_admin:/home/oracle>

    Best regards,

    Carel-Jan Engel

    ===
    If you think education is expensive, try ignorance. (Derek Bok)
    ===
    On Wed, 2006-02-01 at 14:26 +0100, johan Eriksson wrote:

    i think it is the version of the two task protocol, but not sure about
    this.

    /Johan
    On Wed, 2006-02-01 at 14:04 +0100, Foelz.Frank wrote:
    so what is the "8.1.0" which is unique in each OS string ?
    --
    http://www.freelists.org/webpage/oracle-l
    --
    http://www.freelists.org/webpage/oracle-l
  • Bobak, Mark at Feb 1, 2006 at 1:52 pm
    7.1.6.2.0, Carel-Jan? What, you didn't have anything older?;-)



    --
    Mark J. Bobak
    Senior Oracle Architect
    ProQuest Information & Learning

    "There are 10 types of people in the world: Those who understand
    binary, and those who don't."

    ________________________________

    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Carel-Jan Engel
    Sent: Wednesday, February 01, 2006 8:49 AM
    To: johan.eriksson_at_bossmedia.se
    Cc: Foelz.Frank_at_Scheidt-Bachmann.de; ORACLE-L
    Subject: RE: running os command from pl/sql block

    My $0.02:

    ease_at_admin:/home/oracle>sqlplus system

    SQL*Plus: Release 3.1.3.7.1 - Production on Wed Feb 1 14:39:58 2006

    Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

    Enter password:

    Connected to:
    Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and Parallel Server options
    PL/SQL Release 2.1.6.2.0 - Production

    SQL> select dbms_utility.port_string from dual;
    select dbms_utility.port_string from dual
    *
    ERROR at line 1:
    ORA-06571: Function PORT_STRING does not guarantee not to update
    database

    SQL> set serveroutput on
    SQL> declare
    2 result varchar2(80);
    3 begin
    4 result := dbms_utility.port_string;
    5 dbms_output.put_line(result);
    6 end;
    7 /
    SystemV/386-3.2-7.0.0

    PL/SQL procedure successfully completed.

    SQL> exit
    Disconnected from Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and Parallel Server options
    PL/SQL Release 2.1.6.2.0 - Production
    ease_at_admin:/home/oracle>uname -a
    SCO_SV admin 3.2 2 i386
    ease_at_admin:/home/oracle>

    Best regards,

    Carel-Jan Engel

    ===
    If you think education is expensive, try ignorance. (Derek Bok)
    ===

    On Wed, 2006-02-01 at 14:26 +0100, johan Eriksson wrote:

    i think it is the version of the two task protocol, but not sure
    about
    this.

    /Johan
    On Wed, 2006-02-01 at 14:04 +0100, Foelz.Frank wrote:
    so what is the "8.1.0" which is unique in each OS string ?
    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • Niall Litchfield at Feb 2, 2006 at 10:12 am
    Packages didn't make their way into PL/SQL until version 2 of PL/SQL which
    became available with version 7 :).

    I'll get my coat.

    Niall
    On 2/1/06, Bobak, Mark wrote:

    7.1.6.2.0, Carel-Jan? What, you didn't have anything older?;-)



    *--*
    *Mark J. Bobak*
    *Senior Oracle Architect*
    *ProQuest Information & Learning*

    "There are 10 types of people in the world: Those who understand binary,
    and those who don't."


    ------------------------------
    *From:* oracle-l-bounce_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *Carel-Jan Engel
    *Sent:* Wednesday, February 01, 2006 8:49 AM
    *To:* johan.eriksson_at_bossmedia.se
    *Cc:* Foelz.Frank_at_Scheidt-Bachmann.de; ORACLE-L
    *Subject:* RE: running os command from pl/sql block

    My $0.02:

    ease_at_admin:/home/oracle>sqlplus system

    SQL*Plus: Release 3.1.3.7.1 - Production on Wed Feb 1 14:39:58 2006

    Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

    Enter password:

    Connected to:
    Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and Parallel Server options
    PL/SQL Release 2.1.6.2.0 - Production

    SQL> select dbms_utility.port_string from dual;
    select dbms_utility.port_string from dual
    *
    ERROR at line 1:
    ORA-06571: Function PORT_STRING does not guarantee not to update database


    SQL> set serveroutput on
    SQL> declare
    2 result varchar2(80);
    3 begin
    4 result := dbms_utility.port_string;
    5 dbms_output.put_line(result);
    6 end;
    7 /
    SystemV/386-3.2-7.0.0

    PL/SQL procedure successfully completed.

    SQL> exit
    Disconnected from Oracle7 Server Release 7.1.6.2.0 - Production Release
    With the distributed, replication and Parallel Server options
    PL/SQL Release 2.1.6.2.0 - Production
    ease_at_admin:/home/oracle>uname -a
    SCO_SV admin 3.2 2 i386
    ease_at_admin:/home/oracle>


    Best regards,

    Carel-Jan Engel

    ===
    If you think education is expensive, try ignorance. (Derek Bok)
    ===


    On Wed, 2006-02-01 at 14:26 +0100, johan Eriksson wrote:

    i think it is the version of the two task protocol, but not sure aboutthis.
    /Johan
    On Wed, 2006-02-01 at 14:04 +0100, Foelz.Frank wrote:> so what is the "8.1.0" which is unique in each OS string ?
    --http://www.freelists.org/webpage/oracle-l



    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Herring Dave - dherri at Feb 2, 2006 at 1:35 pm
    Okay, I'll jump in from the non-Linux world:

    PORT_STRING

    DEC Alpha OSF/1, r1.1-8.1.0

    % uname -a
    OSF1 V5.1 2650 alpha

    Its nice to see DEC is still mentioned after Compaq and HP did their
    purchases. You think Oracle admits anywhere internally optimizer logic
    they took from Rdb? :-)

    Dave

    Dave Herring, DBA
    Acxiom Corporation
    3333 Finley
    Downers Grove, IL 60515
    wk: 630.944.4762
    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Mladen Gogala
    Sent: Wednesday, February 01, 2006 6:54 AM
    To: Mark.Bobak_at_il.proquest.com
    Cc: davidsharples_at_gmail.com; Stephane Faroult;
    onkarnath.tiwary_at_gmail.com;
    gorbyx_at_gmail.com; ORACLE-L
    Subject: Re: running os command from pl/sql block

    When everybody is publishing port string, let me join the fray:

    SQL> select dbms_utility.port_string from dual;

    PORT_STRING
    >

    --
    ------
    Linuxi386/Linux-2.0.34-8.1.0

    SQL>

    It doesn't even say "IBMPC".

    --
    Mladen Gogala
    http://www.mgogala.com

    --
    http://www.freelists.org/webpage/oracle-l
    ***************************************************************************
    The information contained in this communication is confidential, is
    intended only for the use of the recipient named above, and may be legally
    privileged.

    If the reader of this message is not the intended recipient, you are
    hereby notified that any dissemination, distribution or copying of this
    communication is strictly prohibited.

    If you have received this communication in error, please resend this
    communication to the sender and delete the original message or any copy
    of it from your computer system.

    Thank You.
    ****************************************************************************
  • Kevin Lidh at Feb 2, 2006 at 2:34 pm
    I haven't seen this one in the list yet but I have:

    select dbms_utility.port_string from dual;

    PORT_STRING

    x86_64/Linux 2.4.xx

    Which is interesting since I'm at the 2.6 kernel. Ah well, what Oracle
    doesn't know...

    Kevin
    On 2/2/06, Herring Dave - dherri wrote:

    Okay, I'll jump in from the non-Linux world:

    PORT_STRING
    ------------------------------------------------------------------------
    ------------------------------------------------------------
    DEC Alpha OSF/1, r1.1-8.1.0

    % uname -a
    OSF1 V5.1 2650 alpha

    Its nice to see DEC is still mentioned after Compaq and HP did their
    purchases. You think Oracle admits anywhere internally optimizer logic
    they took from Rdb? :-)

    Dave
    -------------------------------------
    Dave Herring, DBA
    Acxiom Corporation
    3333 Finley
    Downers Grove, IL 60515
    wk: 630.944.4762

    -------------------------------------
    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Mladen Gogala
    Sent: Wednesday, February 01, 2006 6:54 AM
    To: Mark.Bobak_at_il.proquest.com
    Cc: davidsharples_at_gmail.com; Stephane Faroult;
    onkarnath.tiwary_at_gmail.com;
    gorbyx_at_gmail.com; ORACLE-L
    Subject: Re: running os command from pl/sql block

    When everybody is publishing port string, let me join the fray:

    SQL> select dbms_utility.port_string from dual;

    PORT_STRING
    ------------------------------------------------------------------------
    --
    ------
    Linuxi386/Linux-2.0.34-8.1.0

    SQL>
    It doesn't even say "IBMPC".

    --
    Mladen Gogala
    http://www.mgogala.com

    --
    http://www.freelists.org/webpage/oracle-l
    ***************************************************************************
    The information contained in this communication is confidential, is
    intended only for the use of the recipient named above, and may be legally
    privileged.

    If the reader of this message is not the intended recipient, you are
    hereby notified that any dissemination, distribution or copying of this
    communication is strictly prohibited.

    If you have received this communication in error, please resend this
    communication to the sender and delete the original message or any copy
    of it from your computer system.

    Thank You.

    ****************************************************************************
    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • Norman Dunbar at Feb 2, 2006 at 3:34 pm
    Maybe LD_ASSUME_KERNEL (or whatever it is) is in force ?
    Dunno, just a guess.

    Cheers,
    Norman.

    Norman Dunbar.
    Contract Oracle DBA.
    Rivers House, Leeds.

    Internal : 7 28 2051
    External : 0113 231 2051
    Kevin Lidh 02/02/06 02:34pm >>>
    I haven't seen this one in the list yet but I have:

    select dbms_utility.port_string from dual;

    PORT_STRING

    x86_64/Linux 2.4.xx

    Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

    We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.

    We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

    If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedFeb 1, '06 at 6:21a
activeFeb 2, '06 at 3:34p
posts23
users14
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase