DeleteCustomerById


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   CUSTOMERS   >   DeleteCustomerById   

Procedure body DeleteCustomerById(customer_Id NUMBER), Package CUSTOMERS

Name Datatype Precision Description
customer_Id NUMBER NUMBER, parameter of CUSTOMERS.DeleteCustomerById
Name Types Value
No Data
Name Definition
No Data

procedure DeleteCustomerById( customer_Id   in NUMBER )
    is
    begin
      CheckCustomer(customer_Id);
      DELETE CUSTOMER where ID = id;
      COMMIT;
    end DeleteCustomerById

     
Name Types Description
CUSTOMER Table Table
<DEFAULT SCHEMA>.CUSTOMERS.DeleteCustomerById Procedure Procedure interface DeleteCustomerById(customer_Id NUMBER), Package CUSTOMERS
<DEFAULT SCHEMA>.CUSTOMERS.CheckCustomer Function Function body CheckCustomer(customer_Id NUMBER) return CheckCustomer, Package CUSTOMERS
NUMBER PL/SQL System type PL/SQL System Object
ID Undefined Item

     
No Data