ERROR at line 1:
ORA-06550: line 1, column 22:
PLS-00302: component 'PAK_POPL_SUPPL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


SHELL SCRIPT:
#!/bin/ksh
# File : run_package.sh
# --------------------------------------------------
ORACLE_HOME=/opt/oracle/10.2.0
export ORACLE_HOME
PATH=$PATH:/opt/oracle/10.2.0/bin
export PATH
UNAME=dml_prod
PASS=dml_prod
ORACLE_SID=cb22
sqlplus -s $UNAME@$ORACLE_SID/$PASS << !
SET heading off
SET feedback off
echo "Running Package pak_popl_suppl"
EXEC pak_popl_suppl.pr_supplier_update;
!
if [ $? -eq 0 ]
then
echo "suceess"
return $?
else
echo "Fail"
return $?
fi


ORACLE PROCEDURE:
CREATE OR REPLACE PACKAGE pak_popl_suppl
IS
PROCEDURE pr_supplier_update;
END PAK_POPL_SUPPL;
/
CREATE OR REPLACE PACKAGE BODY pak_popl_suppl
IS
PROCEDURE pr_supplier_update
IS
CURSOR c_new_supplier IS
SELECT
sps.entity_cd,
sps.supplier_id,
sps.supplier_name,
sps.address_line1 ,
sps.address_line2 ,
sps.address_line3 ,
sps.city ,
sps.post_code ,
sps.state ,
sps.country ,
sps.phone_number ,
sps.currency ,
sps.fax_number ,
sps.email_address
FROM stage_popl_supplier sps
WHERE NOT EXISTS(SELECT *
FROM popl_supplier ps
WHERE sps.entity_cd = ps.entity_cd
AND sps.supplier_id = ps.supplier_id)
AND sps.entity_cd <> '****'; -- exclude the dummy Supplier added Brian Clark 10 Nov 2011
v_count NUMBER :=0;
BEGIN
FOR v_new_supp IN c_new_supplier LOOP
v_count := v_count +1;
INSERT INTO popl_supplier
VALUES
(
v_new_supp.entity_cd,
v_new_supp.supplier_id,
v_new_supp.supplier_name,
v_new_supp.address_line1,
v_new_supp.address_line2,
v_new_supp.address_line3,
v_new_supp.city,
v_new_supp.post_code,
v_new_supp.state,
v_new_supp.country,
v_new_supp.phone_number,
v_new_supp.currency,
v_new_supp.fax_number,
v_new_supp.email_address,
(chappi_popl_supplier.NEXTVAL),
'Y'
);
END LOOP;
Dbms_Output.ENABLE(1000000);
Dbms_Output.put_line(v_count);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
Dbms_Output.put_line(SQLCODE ||'-'||SQLERRM);
END pr_supplier_update ;
END PAK_POPL_SUPPL;