UpdateCustomerName

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   CUSTOMERS   >   UpdateCustomerName

Procedure body UpdateCustomerName(customerId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS

Name	Datatype	Precision	Description
customerId	interger		INTERGER, parameter of CUSTOMERS.UpdateCustomerName
fname	nvarchar2		NVARCHAR2, parameter of CUSTOMERS.UpdateCustomerName
lname	nvarchar2		NVARCHAR2, parameter of CUSTOMERS.UpdateCustomerName

procedure UpdateCustomerName(customerId interger, fname in nvarchar2, lname in nvarchar2)
    is
    begin
        UPDATE CUSTOMER
			SET FNAME=fname, LNAME=lname
			WHERE Id = customerId;

    end UpdateCustomerName

Name	Types	Description
CUSTOMER	Table	Table
<DEFAULT SCHEMA>.CUSTOMERS.UpdateCustomerName	Procedure	Procedure interface UpdateCustomerName(customerId INTERGER,fname NVARCHAR2,lname NVARCHAR2), Package CUSTOMERS
FNAME	Column	Virtual column
LNAME	Column	Virtual column
NVARCHAR2	PL/SQL System type	PL/SQL System Object
ID	Undefined Item
INTERGER	Undefined Item