Add support for Oracle nested tables and varrays as stored procedures arguments#347
Add support for Oracle nested tables and varrays as stored procedures arguments#347javornikolov merged 5 commits intodbfit:masterfrom
Conversation
|
@avskor, thanks for the PR! From the Java point of view, this looks broadly ok. Adding another parameter to the initialiser for I'll defer the Oracle part to @javornikolov since I'm so far out of the loop with DBs at the moment. |
|
I agree, the number of parameters is large, but I have tried to minimize changes in core classes |
|
Thank you @avskor! I'll review this PR soon. |
There was a problem hiding this comment.
There should be one space only here after paramPosition,.
|
Extra space removed |
There was a problem hiding this comment.
The proper syntax is to have force option after the type name:
create or replace force type person_type_tab as table of person_type
Otherwise it seems to be ignored and you face error if dependent objects (like the table of person_type) exist:
create or replace force type person_type as object(id number, name varchar2(50 char))
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents
|
It's working fine and except my minor remarks about |
|
Fixed. Execute Ddl used for ddl operation, force option moved after type name |
|
Great :-) @anaclcastro, thank you very much for your contribution! Merging... |
javornikolov
changed the title
Add support for Oracle nested tables and varrays as stored procedures arguments
3 participants
Support for Oracle collections (nested tables and varrays) as stored procedures parameters.
Partially resolves #57