Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL HELP NEEDED!!!!
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
BEGIN INSERT INTO
Customers (CustNO, Firstname, LastName) VALUES (nCustNO, fname, lname);
--Here I'll have to have several another INSERT INTO
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!!!<<<"