Composite arguments and Oracle 18c + about ruby-plsql HOT 9 CLOSED

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.

@jgebal Did you encounter any issues related to this? On Oracle 19 we are seeing odd behavior. When a function returns a record the result is always an empty object {}. Is this related? Thanks

from ruby-plsql.

Not sure. I'm not using ruby-plsql for quite some time now.

from ruby-plsql.

@jgebal I'm curious. What alternative are you using?

from ruby-plsql.

I'm using utPLSQL v3
It is using rspec-like expectations syntax in pure PLSQL.

from ruby-plsql.

from ruby-plsql.

@bpom how did you "adapt ruby-plsql to 19c" . could you please share the details?

from ruby-plsql.

@AvneetBaweja which details do you need? You can review the pull request #196

As a summary: for records, associative arrays and cursors the metadata are now selected from all_plsql_types, all_plsql_coll_types, all_plsql_type_attrs instead of all_arguments since Oracle has removed the entries for such types in 18c

from ruby-plsql.

Hello @bpom and @yahonda

I see that the changes usder this pull reqyuest has been released into latest version of ruby-plsql gem.

I have installed the required gems on my machine but i am not able to work with complex datatypes in oracle 19c.

here is my list of gems
*** LOCAL GEMS ***

bigdecimal (default: 1.2.8)
builder (3.2.4)
bundler (2.2.25)
did_you_mean (1.0.0)
diff-lcs (1.4.4)
io-console (default: 0.4.5)
json (default: 1.8.3)
mini_portile2 (2.1.0)
minitest (5.8.5)
net-telnet (0.1.1)
nokogiri (1.6.8.1 x64-mingw32)
power_assert (0.2.6)
psych (default: 2.1.0)
rake (10.4.2)
rdoc (default: 4.2.1)
rspec (3.10.0)
rspec-core (3.10.1)
rspec-expectations (3.10.1)
rspec-mocks (3.10.2)
rspec-support (3.10.2)
rspec_junit_formatter (0.4.1, 0.2.3)
ruby-oci8 (2.2.8 x64-mingw32, 2.2.4 x64-mingw32)
ruby-plsql (0.8.0, 0.7.1)
ruby-plsql-spec (0.5.0)
rubygems-update (3.2.25)
test-unit (3.1.5)
thor (0.19.4)

And this is the error i am getting when trying to run a package function.

1. control_sheets GIVEN a call to get_param_value WHEN parameter array is empty it returns null
   Failure/Error: plsql.control_sheet.get_param_value(nil,-1)

   OCIError:
   ORA-00911: invalid character
   ORA-06512: at line 4
   stmt.c:267:in oci8lib_230.so
   ./spec/unit/controlSheetTest.rb:213:in block (3 levels) in <top (required)>' ./spec/spec_helper.rb:80:in block (2 levels) in <top (required)>'

The exact call works in 11g oracle . Could you please help me here. Thanks

from ruby-plsql.