storedprocedure.sql

Adding and making operations LOB data in a database with C#

CREATE OR REPLACE PROCEDURE setProductImage(p_ProductID IN NUMBER, p_ProductImage IN BLOB)
IS
/**
*  @author  : Chandar 
*  @version : 1.0
*
*  Name of the Application        :  StoredProcedure.sql
*  Creation/Modification History  :  03-Aug-2001
*
*  Overview of  Procedure:
*  This procedure is called from LOBSample.SLN VC# application. It is used to update 
*  the product image for the given product. The product Image is of LOB type.
*
*  Parameters :
*  @p_ProductID - IN - Product Id passed from the updateProdcutImage function in ADOHandler.cs source file.
*  @p_ProductImage - IN - Product Image passed from the updateProductImage function in ADOHandler.cs source file.
**/
BEGIN
   UPDATE product_information SET Product_Image = p_productImage
     WHERE Product_ID = p_ProductID;
  COMMIT;
END;
/

CREATE OR REPLACE PROCEDURE getProductImage(p_ProductID IN NUMBER, p_ProductImage OUT BLOB)
is
/**
  *  @author  : Chandar 
  *  @version : 1.0
  *
  *  Name of the Application        :  getProductImage
  *  Creation/Modification History  :  03-Aug-2001
  *
  *  Overview of  Procedure:
  *  This procedure is called from LOBSample.SLN VC# application. Based on the product_ID passed 
  *  to the procedure, its corresponding product_image is fetched from the 
  *  Product_Information table. 
  *
  *  Parameters :
  *  @p_ProductID - IN - Product Id passed from the GetProductImage ADOHandler.cs source file.
  *  @p_ProductImage - OUT - Product Image passed to the GetProductImage function ADOHandler.cs source file.
  **/
BEGIN
  SELECT product_image INTO p_ProductImage FROM product_information
         WHERE product_ID = p_ProductID;
END;
/