PL/SQL (MOSC)

MOSC Banner

Cursor fails to compile in Forms

edited Jun 27, 2015 10:01AM in PL/SQL (MOSC) 3 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center