|
[oracle-l]
||
[Date Prev]
[02-2006 Date Index]
[Date Next]
||
[Thread Prev]
[02-2006 Thread Index]
[Thread Next]
RE: running os command from pl/sql block
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: johan.eriksson@xxxxxxxxxxxx
- Date: Wed, 01 Feb 2006 14:49:29 +0100
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
>
>
|
|
