'Declare' is not required in a procedure, a basic mistake, a book will help
you learn correct syntax.
Regards,
--
Shariq
Shariq's home page http://www.angelfire.com/az/sharp/
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 Mon Jun 14 1999 - 09:43:57 CDT
