You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, even though the odp.net driver supports associative array binding, it only supports array index by integer.
Is it possible that the driver could support in a future release, array index by varchar2?
So we could map c# hash table to oracle pl/sql ones.
Thank's for reply.
DECLARE
SUBTYPE tvalue IS VARCHAR2 (1000);
TYPE thash IS TABLE OF tvalue
INDEX BY VARCHAR2 (50);
hashtab thash;
elem VARCHAR2 (50);
BEGIN
hashtab ('avion') := NULL;
hashtab ('voiture') := '748';
.............................
hashtab ('train') := '749';
hashtab ('bateau') := '750';
hashtab ('velo') := '751';