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