Re: PL/SQL HELP NEEDED!!!!

why do u need a keyword "DECLARE" while creating the procedure. Remove the "declare" and compile the procedure again.

shailaja

Barney Gumble <duff.drinker_at_cornerpub.FUDD-SUX> wrote in message news:3764F083.60DDC4AE_at_cornerpub.FUDD-SUX...
> I'm tying to make a stored procedure that will create new user:
>
> CREATE OR REPLACE
> Procedure pMakeCust(fname IN VarChar2, lname IN VarChar2) AS
>
> DECLARE
> -- CustSeq is my sequence for key-generation.
> nCustNO Number := CustSeq.NextVal;
>
> BEGIN
>
> INSERT INTO
> Customers
> (CustNO, Firstname, LastName)
> VALUES
> (nCustNO, fname, lname);
>
> --Here I'll have to have several another INSERT INTO
> -- that will use same nCustNO
>
> END; -- procedure
>
> Why do I get error: "PLS-00103: Encountered the symbol "DECLARE" ?
> What am I doing wrong? Thanx in advance.
>
> BG :o)
>
> --
> "Your infatuation is based on a physical attraction.
> Talk to the woman and you'll realize you have nothing
> in common. >>>BURP!!!<<<"
> -----------------------------------------------------
> Replace ".FUDD-SUX" with ".com" to reply.
>
>
Received on Tue Jun 15 1999 - 15:09:52 CDT