Re: PLS 00103 error when creating package/body

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.

--
Sybrand Bakker, Senior Oracle DBA