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_at_il.proquest.com> 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_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 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

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