Calling Stored Procedures in packages

From: Filip Hanik <fhanik_at_digitalworkforce.net>
Date: Thu, 1 Jul 1999 12:50:16 -0700
Message-ID: <6CPe3.160$_A1.23069@typhoon-sf.snfc21.pbi.net>

Hi,
I have two stored procedures in my package. When I execute the first one that stored procedure should call and execute the second one first.

The problem is I get this compile error PLS-00103: Encountered symobl create_company_import;

Do the stored procedures have to be declared in a certain order?

Thanks
Filip - Oracle 8.0.5, WinNT 4.0

PROCEDURE import_companies
IS
 CURSOR pscom_cur IS select * from PS_COMPANY_TBL_at_PEOPLESOFT;  pscom_rec pscom_cur%ROWTYPE;
BEGIN  EXECUTE create_company_import;
 OPEN pscom_cur;
 LOOP
  FETCH pscom_cur INTO pscom_rec;
  EXIT WHEN pscom_cur%NOTFOUND;
  EXECUTE insert_company (

   pscom_rec.COMPANY,
   pscom_rec.DESCR,
   pscom_rec.ADDRESS1,
   pscom_rec.ADDRESS2,
   pscom_rec.ADDRESS3,
   pscom_rec.ADDRESS4,
   pscom_rec.CITY,
   pscom_rec.STATE,
   pscom_rec.ZIP,
   pscom_rec.COUNTRY);

 END LOOP;
 CLOSE tc;
END import_companies; Received on Thu Jul 01 1999 - 14:50:16 CDT