RE: running os command from pl/sql block

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