Re: Calling Stored Procedures in packages

A copy of this was sent to "Filip Hanik" <fhanik_at_digitalworkforce.net> (if that email address didn't require changing) On Thu, 1 Jul 1999 12:50:16 -0700, you 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;
>

its the symbol EXECUTE that is really causing the problem. get rid of it. you don't use execute in plsql (its a sqlplus/svrmgrl shortcut for begin ... end; )

you either have to have

• create_company_import declared in the spec
• create_company_import forward declared in the body
• or (easiest) define create_company_import BEFORE import_companies in the package body

as well.

>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;
>
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 01 1999 - 15:08:06 CDT