Re: type table in forms trigger

Pieter-Jan wrote:

> hello,
>
> I've tried to declare a table the following way
>
> type my_table is table of number index by binary integer

TYPE my_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

BYNARY_INTEGER is a NUMBER subtype

After you need to declare a variable (the real array)

var1 my_table;
var2 my_table;

>
>
> this doesn.t work. I've heard something about differences between
> pl/sql and sql in a forms trigger, is that the reason why??

What does it means ? You can use it starting from PL-SQL 2 (for example not in Forms 3.0)

>
>
> thanks
>
> pieter-jan

--
           \\\\////
           &( oo )&
[Quoted] ========oOO==(__)==OOo========
|                            |
|Andrea.Cannaos_at_deagostini.it|
|                            |
==============================
            ||   ||
           (__) (__)