Debugging Problem with Procedure Bulider of DEV2000

[Quoted] I am having an strange problem with the debugger of Procedure Builder of DEV2000!. I can compile the stored procedure at the database level without any problem, but when I move it to Program Unit at the local level I get the following compilation error:

PL/SQL> .load STORED PROGRAMUNIT OPS$VAHIDT.CALL_A_CARD_P2 NAMESPACE / Loading stored Procedure CALL_A_CARD_P2... ERROR 103 at line 3, column 31
  Encountered the symbol "OF" when expecting one of the following:   "("
  Fatal syntax error, unable to recover.

and here is the few lines from the my code:

[Quoted] [Quoted] 00001 PROCEDURE call_a_card_p2 (no_in IN NUMBER, 00002 max_out OUT NUMBER) IS
00003 TYPE f_typ_tab IS TABLE OF NUMBER(38,38) 00004 INDEX BY BINARY_INTEGER;
00005 TYPE tps_typ_tab IS TABLE OF reading.tps_resul_net%TYPE

and it stops at line 00003 before "OF".

It seems it doesn't recognize the TBALE type delaration?! Any help or hint will be greatly welcome.

Adam Tadj
vahidt_at_dbsun.vitek.com Received on Fri May 02 1997 - 00:00:00 CEST