Extended Support for Associative Arrays about ruby-plsql HOT 3 CLOSED

Concerning possible solution a)

SELECT
  NAME, TYPE, USAGE
FROM
  SYS.DBA_IDENTIFIERS
WHERE
  NAME = :1
  AND USAGE = 'DECLARATION'
;

yields

type == ASSOCIATIVE ARRAY if index by VARCHAR2
and
type == INDEX TABLE if index by PLS_INTEGER

This is in my opinion one step closer to solution a).
However I have as of yet not found a way to determine the index length (This could be worked around by setting it to 4000 not great but works).
Additionally as this is undocumented behavior I assume it could be changed at any time.
Trails done against Oracle 12c 12.1.0.2.0 64-bit

I have also thought of simply creating the temp_table and rescuing the exception should the insert fail but have not yet found a concise way to integrate that in to the existing codebase.

from ruby-plsql.

If you are interested in the current solution it can be viewed here:
https://github.com/edthamm/ruby-plsql/pull/1/files

If this is deemed an appropriate solution I will create a pull request containing only the changes relevant to this project

from ruby-plsql.

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

from ruby-plsql.