Re: PL/SQL HELP NEEDED!!!!

Hi Barney Gumble, (Say hi to Betty!)

You don't need the keyword declare when creating procedures/functions. It is only necessary in 'anonymous' blocks.

Mark

Barney Gumble wrote in message <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 - 07:50:23 CDT