Re: Debugging Problem with Procedure Bulider of DEV2000

vahidt_at_dbsun.vitek.com wrote:

> 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

Adam

The problem is that Dev/2000 uses V1 of PL/SQL but the server side is at V2.3 of PL/SQL. Tables are not available in V1. You need to wait until Dev/2000 V2 before you can use tables on the client side. Instead you might consider using a record group in Dev/2000.

Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com Received on Sat May 03 1997 - 00:00:00 CDT