Re: Calling Stored Procedures in packages

Filip

It is a good idea for your create_company_import procedure to exist in the database before you try and compile anything that calls it.

Mark

On Thu, 1 Jul 1999 12:50:16 -0700, "Filip Hanik" <fhanik_at_digitalworkforce.net> wrote:

>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 Tue Jul 06 1999 - 06:24:27 CDT