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?

On 27 Jul 2004 19:11:06 -0700, mjenson43@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.


--
Sybrand Bakker, Senior Oracle DBA

Thanks!

Sybrand Bakker <sybrandb@hccnet.nl> wrote in message news:<srbeg01ia6v5nn1p0f61ogn193t70vq2me@4ax.com>. ..
> On 27 Jul 2004 19:11:06 -0700, mjenson43@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.