Comments (3)
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.
Related Issues (20)
- XMLTYPE in/out binds non-functional in 12C HOT 6
- Selecting out a BLOB object results in an error
- Proposal to drop old versions of Rails, CRuby and JRuby HOT 1
- NoMethodError: undefined method `match' for nil:NilClass when trying to connect with URL, username, password via JDBC HOT 1
- Release require for Ruby v2.4, v2.5 support with no warnings HOT 4
- Thread safety issue in connection.session_id HOT 1
- Can't kill an app with SIGHUP if listening to queue without dequeue_options_t.wait HOT 1
- PLSQL::Variable metadata may query the wrong schema looking up %TYPE and %ROWTYPE HOT 1
- PL/SQL Constant not found HOT 1
- Add ruby-oci8 as a runtime dependency HOT 2
- Composite arguments and Oracle 18c + HOT 9
- Nested array HOT 1
- Support Oracle Database 18.3.0 or higher HOT 13
- OCI8::Cursor was already closed.
- Complex datatypes are not handled with ruby-plsql v 0.8.0 for oracle 19c HOT 13
- 0.8.0 breaks Oracle function
- ruby-plsql 0.8.0: Procedure with parameters referencing system packages fails HOT 3
- ruby-plsql 0.8.0 / Oracle 19c: "No PL/SQL procedure or variable 'VERSION' found" when accessing plsql.dbms_db_version.version
- Session variables with subtypes crash
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ruby-plsql.