Home » Developer & Programmer » Forms » Help with Data Block Based on Procedure--getting compilation error (forms 6i)
Help with Data Block Based on Procedure--getting compilation error [message #579637] Wed, 13 March 2013 15:10 Go to next message
sumitmahajan12
Messages: 4
Registered: April 2008
Junior Member
I am trying to create a datablock based on a procedure , but im getting errors in compilation:
Errors are :
1) identifier 'HSM_WSH_DEL_UTIL.DEL_TBL' must be declared

2) PL/SQL ERROR 320 at line 7, column 27
the declaration of the type of this expression is incomplete or malformed

Any Help would be appreciated !

Heres my pkg spec and body for the data block:

CREATE OR REPLACE PACKAGE hsm_wsh_del_util
IS
   TYPE del_record IS RECORD (delivery_id NUMBER);

   TYPE del_tbl IS TABLE OF del_record
                      INDEX BY BINARY_INTEGER;

   PROCEDURE do_query (p_del IN OUT del_tbl);
END hsm_wsh_del_util;

CREATE OR REPLACE PACKAGE BODY hsm_wsh_del_util
IS
   PROCEDURE do_query (p_del IN OUT del_tbl)
   IS
      idx   NUMBER := 1;

      CURSOR DELIVERY
      IS
         SELECT DELIVERY_ID FROM abc_deliveries;
   BEGIN
      FOR CUR IN DELIVERY
      LOOP
         p_del (idx).delivery_id := cur.delivery_id;
         idx := idx + 1;
      END LOOP;
   END do_query;
END hsm_wsh_del_util;


[EDITED by LF: formatted code and made the message readable]

[Updated on: Fri, 15 March 2013 07:31] by Moderator

Report message to a moderator

Re: Help with Data Block Based on Procedure--getting compilation error [message #579792 is a reply to message #579637] Fri, 15 March 2013 07:19 Go to previous message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
try this link


http://ahmedesokey.blogspot.com/2009/05/using-stored-procedure-with-forms-this.html


Otherwise i shall send u .FMB file


best regard

[Updated on: Fri, 15 March 2013 07:23]

Report message to a moderator

Previous Topic: ORA - 6502 (numeric or value error string) , FRM - 40735
Next Topic: FRM-40735: WHEN - CUSTOM -ITEM -EVENT trigger raised unhandled exception ORA-06509
Goto Forum:
  


Current Time: Sun Dec 28 09:17:11 CST 2014

Total time taken to generate the page: 0.11245 seconds