oracle / oracle/dotnet-db-samples
Passing associative array index by varchar2 from c# to pl/sql
Open
Nobody has claimed this yet.
enhancement
- Dominant language
- C#
- Stars
- 434
- Forks
- 191
- Avg merge
- 1d 15h
- Merged PRs (30d)
- 1
Description
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';
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with ODP.NET associative-array binding and the PL/SQL INDEX BY VARCHAR2 example in the issue. Compare the supported integer-index binding with mapping a C# hash table to the shown PL/SQL type; done means establishing whether varchar2-indexed binding is supported and documenting or demonstrating the resulting behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100