InitProduct

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   PRODUCTS   >   InitProduct

Procedure body InitProduct(name NVARCHAR2), Package PRODUCTS

Name	Datatype	Precision	Description
name	nvarchar2		NVARCHAR2, parameter of PRODUCTS.InitProduct

Name	Types	Value
c	Variable
Impact Analysis:	Object calling \"c\" Object Type <DEFAULT SCHEMA>.PRODUCTS.InitProduct Procedure

Name	Definition
c1	cursor c1 is SELECT name,description, prod_size, quantity,unit_price FROM ALL_NewProduct;

procedure InitProduct( name	in nvarchar2 )
  is
      cursor c1 is
        SELECT name,description, prod_size, quantity,unit_price
        FROM ALL_NewProduct;
  
  begin
  
     for c in c1 loop
        Products.CreateProduct(c.name, c.description, c.prod_size , c.quantity, c.unit_price);
      end loop;
         
  end InitProduct

Name	Types	Description
<DEFAULT SCHEMA>.PRODUCTS	Package	Package, Interface
<DEFAULT SCHEMA>.ALL_NEWPRODUCT	View	View
<DEFAULT SCHEMA>.PRODUCTS.InitProduct	Procedure	Procedure interface InitProduct(name NVARCHAR2), Package PRODUCTS
<DEFAULT SCHEMA>.ALL_NEWPRODUCT.DESCRIPTION	Column	View column
<DEFAULT SCHEMA>.ALL_NEWPRODUCT.NAME	Column	View column
<DEFAULT SCHEMA>.ALL_NEWPRODUCT.PROD_SIZE	Column	View column
<DEFAULT SCHEMA>.ALL_NEWPRODUCT.QUANTITY	Column	View column
<DEFAULT SCHEMA>.ALL_NEWPRODUCT.UNIT_PRICE	Column	View column
NVARCHAR2	PL/SQL System type	PL/SQL System Object
CreateProduct	Undefined Procedure	Function interface CreateProduct() return Virtual

Name	Types	Description
<DEFAULT SCHEMA>.DATA.Startup	Procedure	Procedure body Startup(name NVARCHAR2), Package DATA