Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 31875 invoked from network); 2 Feb 2006 04:12:56 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2006 04:12:56 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BE37290D04; Thu, 2 Feb 2006 05:12:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05833-10; Thu, 2 Feb 2006 05:12:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C4A62290C1B; Thu, 2 Feb 2006 05:12:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 02 Feb 2006 05:12:37 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 586FA290C2B for ; Thu, 2 Feb 2006 05:12:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05596-07 for ; Thu, 2 Feb 2006 05:12:37 -0500 (EST) Received: from uproxy.gmail.com (uproxy.gmail.com [66.249.92.192]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C5A70290BAD for ; Thu, 2 Feb 2006 05:12:36 -0500 (EST) Received: by uproxy.gmail.com with SMTP id c2so102962ugf for ; Thu, 02 Feb 2006 02:12:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=KsIEIGny7krpNtzWRypAPk8pePiGI8uCvcK4s9Ov0/1FmHvsExNz1Cr4MSuVlKDb8Mb7k42RksRZdTrSbAr9bz8wCo2akAEdHejNS5H4h6MTiCJhUBnEmtBO30uLKkgDq0zOt9FKWaQ8V4HE9aki5HRD1M96OvND5t0/2Tx3BOs= Received: by 10.49.20.3 with SMTP id x3mr66262nfi; Thu, 02 Feb 2006 02:12:35 -0800 (PST) Received: by 10.48.211.19 with HTTP; Thu, 2 Feb 2006 02:12:35 -0800 (PST) Message-ID: <7765c8970602020212h390e03eme59492ac38cd7c17@mail.gmail.com> Date: Thu, 2 Feb 2006 10:12:35 +0000 From: Niall Litchfield To: Mark.Bobak@il.proquest.com Subject: Re: running os command from pl/sql block Cc: cjpengel.dbalert@xs4all.nl, johan.eriksson@bossmedia.se, Foelz.Frank@scheidt-bachmann.de, ORACLE-L In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11680_949400.1138875155100" References: X-archive-position: 30693 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net ------=_Part_11680_949400.1138875155100 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Packages didn't make their way into PL/SQL until version 2 of PL/SQL which became available with version 7 :). I'll get my coat. Niall On 2/1/06, Bobak, Mark wrote: > > 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@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Carel-Jan Engel > *Sent:* Wednesday, February 01, 2006 8:49 AM > *To:* johan.eriksson@bossmedia.se > *Cc:* Foelz.Frank@Scheidt-Bachmann.de; 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 :=3D 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 > > =3D=3D=3D > If you think education is expensive, try ignorance. (Derek Bok) > =3D=3D=3D > > > 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 aboutthi= s. > /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 > > > > > -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ------=_Part_11680_949400.1138875155100 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Packages didn't make their way into PL/SQL until version 2 of PL/SQL which = became available with version 7 :).

I'll get my coat.

Niall=



On 2/1/06, Bobak, Mark <Mark.Boba= k@il.proquest.com> wrote:
7.1.6.2.0, Carel-Jan?  What, you didn't have anything=20 older? ;-)
 
 

--=20
Mark J= .=20 Bobak
Senior Oracle Architect
<= span lang=3D"en-us">P roQuest Information & Learning=20

"There are 10 ty= pes of people in=20 the world:  Those who understand binary, and those who=20 don't."

 

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@fr= eelists.org] On Behalf Of Carel-Jan=20 Engel
Sent: Wednesday, February 01, 2006 8:49 AM
To:=20 johan.eriksson@bossmedia.se<= /a>
Cc: Foelz.Frank@Scheidt-Bachmann.de;=20 ORACLE-L
Subject: RE: running os command from pl/sql=20 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 reserve=
d.


Enter password:

Connected to:
Oracle7 Server Release 7.1.6.2.=
0 - Production Release
With the distributed, replication and Parallel Se=
rver 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
    &n=
bsp;  *
ERROR at line 1:
ORA-06571: Function PORT_STRING does no=
t guarantee not to update database


SQL> set serveroutput onSQL> declare
  2    result varchar2(80);

  3  begin
  4    result :=3D dbms_uti=
lity.port_string;
  5    dbms_output.put_line(result=
);
  6  end;
  7  /
SystemV/386-3.2-7.0.0
<=
br>PL/SQL procedure successfully completed.

SQL> exit
Disconne=
cted from Oracle7 Server Release=20
7.1.6.2.0 - Production Release
With the distributed, replication and Par=
allel 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/or=
acle>



Best regards,

Carel-Jan Engel

=3D=3D=3D<=
br>If you think education is expensive, try ignorance. (Derek Bok)
=3D=
=3D=3D

On Wed, 2006-02-01 at 14:26 +0100, johan Eriksson wrote:=20 
i think it is the ve=
rsion of the two task protocol, but not sure about
this.

/Johan

On Wed, 2006-02-01 at 14:04 +0100, Foelz.Frank wrot=
e:
> so what is the "8.1.0" which is uniq=
ue in each OS string ?

--
http://www.freelists.org/webpage/oracle-l





--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com ------=_Part_11680_949400.1138875155100-- -- http://www.freelists.org/webpage/oracle-l