GetOrderById

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALEORDER   >   GetOrderById

Procedure body GetOrderById(orderId NUMBER), Package SALEORDER

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

Name	Types	Value
r1	Variable
Impact Analysis:	Object calling \"r1\" Object Type <DEFAULT SCHEMA>.SALEORDER.GetOrderById Procedure

Name	Definition
c1	cursor c1 is SELECT Id, Cust_id, Fin_Code_Id, order_date, Sales_Rep,Total_HT,EmployeeId,EmployeeFname,EmployeeLname FROM ALL_ORDERS_By_Employee Where Id = orderId;

procedure GetOrderById( orderId   in NUMBER )
    is
	cursor c1 is
			SELECT Id, Cust_id, Fin_Code_Id, order_date, Sales_Rep,Total_HT,EmployeeId,EmployeeFname,EmployeeLname
			FROM ALL_ORDERS_By_Employee Where Id = orderId;
    begin
          for r1 in c1 loop
			dbms_output.put_line(
				lpad(r1.ID,12)
			);
			end loop;
    end GetOrderById

Name	Types	Description
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE	View	View
<DEFAULT SCHEMA>.SALEORDER.GetOrderById	Procedure	Procedure interface GetOrderById(orderId NUMBER), Package SALEORDER
LPAD	Function	PL/SQL System Function
DBMS_OUTPUT.PUT_LINE	Function	PL/SQL System Function
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.CUST_ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEEFNAME	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEEID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.EMPLOYEELNAME	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.FIN_CODE_ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.ID	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.ORDER_DATE	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.SALES_REP	Column	View column
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.TOTAL_HT	Column	View column
NUMBER	PL/SQL System type	PL/SQL System Object
PUBLIC.DBMS_OUTPUT	Synonym	PL/SQL System Synonym