"Maximus" <asdfasdasd_at_eqeqweqwe.com> writes:
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:7jb7kv8ncctbrtdtru8sv9rvs1ftiimoi9_at_4ax.com...
>> On Wed, 20 Aug 2003 17:02:58 GMT, "Maximus" <asdfasdasd_at_eqeqweqwe.com>
>> wrote:
>>
>> >it compiles and works as documented. However, in Forms Developer I get a
>> >compile error "no function 'VARCHAR2' exists in this scope."
>>
>> The type definition doesn't make sense. Why you would index a table by
>> a varchar2?
>
> For associative array functionality (it's a documented feature in the 9i R2
> PL/SQL reference) for key/value pairs:
>
> DECLARE
> TYPE CUST_ID_TYPE IS TABLE OF NUMBER INDEX BY VARCHAR(30);
> CUST_ID CUST_ID_TYPE;
> ID NUMBER;
> BEGIN
> CUST_ID('FLINTSONE') := 1;
> CUST_ID('RUBBLE') := 7;
> ID := CUST_ID('FLINTSTONE');
> ...
> END;
Especially, perl programer like this feature :).
Harald
Received on Wed Aug 20 2003 - 12:41:34 CDT
