Re: Debugging Problem with Procedure Bulider of DEV2000

From: Gerard H. Pille <gerard_h_pille_at_hotmail.com>
Date: 1997/05/04
Message-ID: <01bc58bb$8a5fe400$3e0d4ac1_at_PCGHP>#1/1


PB has PL/SQL V1, while the database has a V2. V1 doesn't provide tables.

Adam Tadj <vahidt_at_dbsun.vitek.com> schreef in artikel <336A65A5.4E75_at_dbsun.vitek.com>...
> 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:
>
> 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 Sun May 04 1997 - 00:00:00 CEST

Original text of this message