Adam vonNieda wrote: > > Here's the output from Oracle 7.3.4.. This is on a Solaris 8 box.. > > dbms_utility.db_version does not appear to exist on Oracle7.. > > -Adam > > [oracle@mastiff /oracle]$ sqlplus sys/password > > SQL*Plus: Release 3.3.4.0.1 - Production on Fri Jan 25 17:25:00 2002 > > Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. > > Connected to: > Oracle7 Server Release 7.3.4.3.0 - Production > With the distributed, replication and parallel query options > PL/SQL Release 2.3.4.3.0 - Production > > SQL> @test > SQL> select * from v$version; > > BANNER > ---------------------------------------------------------------- > Oracle7 Server Release 7.3.4.3.0 - Production > PL/SQL Release 2.3.4.3.0 - Production > CORE Version 3.5.4.0.0 - Production > TNS for Solaris: Version 2.3.4.0.0 - Production > NLSRTL Version 3.2.4.0.0 - Production > > SQL> > SQL> select * from PRODUCT_COMPONENT_VERSION; > > PRODUCT > ---------------------------------------------------------------- > VERSION > ---------------------------------------------------------------- > STATUS > ---------------------------------------------------------------- > CORE > 3.5.4.0.0 > Production > > NLSRTL > 3.2.4.0.0 > Production > > PRODUCT > ---------------------------------------------------------------- > VERSION > ---------------------------------------------------------------- > STATUS > ---------------------------------------------------------------- > > Oracle7 Server > 7.3.4.3.0 > Production > > PL/SQL > 2.3.4.3.0 > > PRODUCT > ---------------------------------------------------------------- > VERSION > ---------------------------------------------------------------- > STATUS > ---------------------------------------------------------------- > Production > > TNS for Solaris: > 2.3.4.0.0 > Production > > SQL> > SQL> rem set serveroutput on; > SQL> rem declare > SQL> rem v varchar2(255); > SQL> rem c varchar2(255); > SQL> rem begin > SQL> rem dbms_utility.db_version( v, c ); > SQL> rem dbms_output.put_line( v ); > SQL> rem dbms_output.put_line( c ); > SQL> rem end; > SQL> rem / > SQL> > SQL> select dbms_utility.port_string from dual; > > PORT_STRING > -------------------------------------------------------------------------------- > SVR4-be-7.0.0 >
> -- > > [EMAIL PROTECTED] > http://www.oracletool.com Many thanks Adam! Steffen
