Re: running os command from pl/sql block

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.Bobak@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Carel-Jan Engel
> *Sent:* Wednesday, February 01, 2006 8:49 AM
> *To:* johan.eriksson@xxxxxxxxxxxx
> *Cc:* Foelz.Frank@xxxxxxxxxxxxxxxxxxx; 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 := 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 aboutthis.
> /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

Other related posts: