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
> 
>

Other related posts: