Change: script variable:
[code]typeset
-i-ix PAC_CNT=`sqlplus -s / <<-EOF
set heading off
set feedback off
SET NUMFORMAT 99999999
WHENEVER SQLERROR EXIT SQL.SQLCODE
WHENEVER OSERROR EXIT SQL.OSCODE
select count(0)
FROM all_objects ao
WHERE ao.owner =
'RP''MY_OWNER' AND ao.object_name =
'RPD1105''MY_PACKAGE' AND ao.object_type = 'PACKAGE'; EOF`
[/code]
View changes from previous version.
(Word count: 84)