REM ODMA "entry point" script for upgrading "Oracle JServer" from any REM Oracle 8.0 or later version to the current Oracle version. SET SERVEROUTPUT ON; DECLARE lcount1 NUMBER; BEGIN DBMS_OUTPUT.new_line; lcount1 := 0; SELECT count(*) into lcount1 FROM sys.obj$ WHERE type# = 29; IF lcount1 = 0 THEN DBMS_OUTPUT.PUT_LINE('ODMA_DIRECTIVE:NOT_INSTALLED:'); ELSE DBMS_OUTPUT.PUT_LINE( 'ODMA_DIRECTIVE:SCRIPT:UPGRADE:javavm/install/jvmempty.sql:'); END IF; END; /