whenever sqlerror exit sql.sqlcode; /* $Header: wfhtpchk.sql 26.0 2000/07/05 22:54:38 kma ship $ */ rem . rem This will cause a sql error if toolkit is not installed rem which will be detected by the installer rem Note: run as SYS to ensure access to all_objects rem . select to_number('abc') from dual where not exists (select 'App Server toolkit is installed' from all_objects where (object_type='SYNONYM' and OWNER='PUBLIC' and object_name = 'HTP') or (object_type='PACKAGE' and OWNER=upper('&1') and object_name = 'HTP')); exit;