More Oracle data types supported by ruby-plsql gem version 0.4.0

[Raimonds Simanovskis]

Couple days ago I released ruby-plsql gem version 0.4.0 which supports
PL/SQL procedures with more complex Oracle data type parameters -
records, objects types, TABLE, VARRAY, BOOLEAN, cursors.

Here is my blog post about these new features:
http://blog.rayapps.com/2009/11/25/more-oracle-data-types-supported-by-ruby-plsql-gem/

Please try it out and I would like to hear if there are any issues
with PL/SQL procedure calls in your projects or if there are any still
unsupported parameter types that you need.

In this version I did quite big refactoring of ruby-plsql internals.
It has also quite big test suite but still it is possible that some
edge cases are not covered therefore hoping to get feedback from ruby-
plsql users :)

Raimonds

[Daniel Berger]

On Nov 25, 7:56 am, Raimonds Simanovskis

<raimonds.simanovs...@gmail.com> wrote:
> Couple days ago I released ruby-plsql gem version 0.4.0 which supports
> PL/SQL procedures with more complex Oracle data type parameters -
> records, objects types, TABLE, VARRAY, BOOLEAN, cursors.
>

> Here is my blog post about these new features:http://blog.rayapps.com/2009/11/25/more-oracle-data-types-supported-b...

>
> Please try it out and I would like to hear if there are any issues
> with PL/SQL procedure calls in your projects or if there are any still
> unsupported parameter types that you need.
>
> In this version I did quite big refactoring of ruby-plsql internals.
> It has also quite big test suite but still it is possible that some
> edge cases are not covered therefore hoping to get feedback from ruby-
> plsql users :)

Pretty cool, thanks.

Is there any chance of this library ever allowing me to write Oracle
functions, procs and triggers in Ruby? Or is there another library out
there that does it?

Regards,

Dan

[Raimonds Simanovskis]

I had some ideas that probably it would be possible to load JRuby Java
classes into Oracle database and then create Oracle Java stored
procedure wrappers which would call Ruby methods (don't know what
would be the best way how to store Ruby source code in the database -
probably it would be necessary to compile Ruby to Java at first and
then store it as Java stored procedure).

But I doubt that it will perform efficiently and also I think that it
is better to put Ruby programs on application server and not inside
database.
But it might be fun experiment, maybe I will try it one day :)

Raimonds