You should make sure that you created the package in the right place.
try running this and posting the results.
Code:set linesize 90 column owner format a20 column object_name format a30 column object_type format a20 show user select owner, object_name, object_type from dba_objects where object_name='SAMIR_TEST' order by 1,2,3;





Reply With Quote