Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLS 00103 error when creating package/body
Thanks!
Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<srbeg01ia6v5nn1p0f61ogn193t70vq2me_at_4ax.com>...
> On 27 Jul 2004 19:11:06 -0700, mjenson43_at_cambridgecollege.edu (Maria
> J) wrote:
>
> >This is the code:
> >
> >CREATE or REPLACE PACKAGE wishlist
> >IS
> >PROCEDURE p_wishlist (customer number, isbn varchar2); -- Adding
> >Information to Wish List
> >END wishlist;
> >
> >-- Creating Package Body for Bookstore Purchases/Holds
> >CREATE or REPLACE PACKAGE BODY wishlist
> >AS
> > PROCEDURE p_wishlist(CUSTOMER number, ISBN varchar2)
> >IS
> >BEGIN
> > Insert into tbl_wishlist
> > VALUES(CUSTOMER, ISBN);
> >COMMIT;
> >END;
> >/
> >
> >I am getting a PLS 00103 - Encountered the Symbol "CREATE" - at line 6
> >(where the body begins).
> >
> >I am butting my head on the table here - what obvious thing am I
> >missing?
>
> a / after the package definition.
>
> You also shouldn't commit in procedures.
Received on Wed Jul 28 2004 - 10:36:35 CDT