Cursor fails to compile in Forms
Hello all,
I have a simple procedure that fails to compile in Forms 10 and I'm hoping someone can point out my obvious mistake.
The error I get is: Encountered the symbol "C1" when expecting one of the following: :=.(@%;
Thanks for the help.
Rogers
/******************************************************************
Update Boxes
******************************************************************/
PROCEDURE update_boxes IS
i NUMBER := 0;
l_lot VARCHAR2(50);
l_organization_id NUMBER;
l_inventory_item_id NUMBER;
l_boxes NUMBER;
l_error VARCHAR2(1000);
BEGIN
mo_global.init('INV');
l_boxes := :xxprk_onhand_inventory_v.boxes;
l_organization_id := :xxprk_onhand_inventory_v.org_id;
l_inventory_item_id := :xxprk_onhand_inventory_v.inventory_item_id;