Description
ShowProductInfo shows information on a product. It takes the product identifier as an argument.
Procedure properties
| name | value |
|---|
| name | GROUPO.ShowProductInfo
|
| created |
|
| type | SQL stored procedure
|
Parameters
| name | datatype | length | in/out | comment |
|---|
| product_ID | integer | 4 | in/out | |
Usage
EXEC GROUPO.ShowProductInfo
product_ID = @myinteger1Dependency graph
Objects that GROUPO.ShowProductInfo depends on
Code
create procedure GROUPO.ShowProductInfo( inout product_ID integer )
result( ID integer,
Name char(15),
Description char(30),
Size char(18),
Color char(6),
Quantity integer,
UnitPrice decimal(15,2) )
begin
select ID,Name,Description,Size,Color,Quantity,UnitPrice
from GROUPO.Products
where Products.ID = product_ID
end