Need help quick!!

From: Flea <nomadeflea_at_yahoo.fr>
Date: 26 Jan 2003 08:37:31 -0800
Message-ID: <24083942.0301260837.513771c1_at_posting.google.com>


Hi,

New to pl/sql, I need some help fast!!
I would like to create a procedure, simply to make an update of a new client:
I would like to create a new client, adding his name, surname, adresse and telephone, and to raise exceptions, if I type the wrong data in
the wrong field, for instance:
I have already created my table:
CREATE TABLE CLIENT
   (
    CODE_CLIENT NUMBER(10) NOT NULL,
    NAME VARCHAR2(15) NULL,

    SURNAME VARCHAR2(15)  NULL,
    ADRESSE VARCHAR2(30)  NULL,
    TELEPHONE NUMBER(12) NOT  NULL

, CONSTRAINT PK_CLIENT PRIMARY KEY (CODE_CLIENT)    ) ;

I am just not sure of what
How should my procedure be constructed?
What should I put in?
Please help! Received on Sun Jan 26 2003 - 17:37:31 CET

Original text of this message