Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Calling Stored Procedures in packages

Re: Calling Stored Procedures in packages

From: Satish <somasatish_at_hotmail.com>
Date: 1 Jul 1999 19:32:59 -0500
Message-ID: <377bfaab@discussions>

Just check out wether the first package or procedure is compiled completely. I think there is some syntax error.

"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 Thu Jul 01 1999 - 19:32:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US