FreeLists / oracle-l / RE: running os command from pl/sql block

["Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Carel-Jan Engel
Sent: Wednesday, February 01, 2006 8:49 AM
To: johan.eriksson@xxxxxxxxxxxx
Cc: Foelz.Frank@xxxxxxxxxxxxxxxxxxx; ORACLE-L
Subject: RE: running os command from pl/sql block


My $0.02: 

ease@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@admin:/home/oracle>uname -a
SCO_SV admin 3.2 2 i386
ease@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
        
        



        

BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD