DeleteOrderById

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALEORDER   >   DeleteOrderById

Procedure body DeleteOrderById(orderId NUMBER), Package SALEORDER

Name	Datatype	Precision	Description
orderId	NUMBER		NUMBER, parameter of SALEORDER.DeleteOrderById

Name	Types	Value
employeeId	Variable
No Reference found for \"employeeId\"

Name	Definition
c1	cursor c1 is SELECT EmployeeId FROM ALL_ORDERS_By_Employee emp where orderId = emp.Id;

procedure DeleteOrderById( orderId   in NUMBER )
    is
   
        employeeId  employees.last_name%TYPE;
        cursor c1 is
           SELECT EmployeeId
            
            FROM ALL_ORDERS_By_Employee emp where orderId = emp.Id;
   begin
        
        
    
         DELETE SALES_ORDER where id = orderId;
         
         
         
		COMMIT;
    end DeleteOrderById

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEES	Package	Package, Interface
<DEFAULT SCHEMA>.SALES_ORDER	Table	Table
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE	View	View
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderById	Procedure	Procedure interface DeleteOrderById(orderId NUMBER), Package SALEORDER
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEEID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.ID	Column	View column
NUMBER	PL/SQL System type	PL/SQL System Object
last_name	Undefined Item
<DEFAULT SCHEMA>.SALES_ORDER.ID	Primary Key	Column