Subscribe: Comments on Blog: Ruby: Invoking a PL/SQL Package with Array args
http://jasonvogel.blogspot.com/feeds/5398647295291291696/comments/default
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
array string  array strings  array  blog  code  dig oci  driver neither  driver  oci driver  plug blogspot  ruby  sql  string array  string  work 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Comments on Blog: Ruby: Invoking a PL/SQL Package with Array args

Comments on Blog: Ruby: Invoking a PL/SQL Package with Array args





Updated: 2017-11-15T09:47:28.463-06:00

 



Sorry, what do you mean? Are you asking how I do ...

2009-08-14T13:49:09.333-05:00

Sorry, what do you mean? Are you asking how I do the code formatting? If so, look at http://jasonvogel.blogspot.com/2009/01/syntax-highlighting-posted-code.html.



Where can I plug a blogspot.com blog to display an...

2009-08-06T07:01:52.194-05:00

Where can I plug a blogspot.com blog to display and highlight the code?



About your first solution: Why using an OUT parame...

2008-01-16T07:26:00.000-06:00

About your first solution: Why using an OUT parameter in a PL/SQL FUNCTION? This will never work. OUT Parameters will only work in PL/SQL PROCEDURES.

In PL/SQL FUNCTIONS you have to use the return value. Like in your final solution. ;-)



I did dig down into OCI8 driver [some]. Neither "...

2006-11-21T15:24:00.000-06:00

I did dig down into OCI8 driver [some]. Neither "String[]" nor "Array" are supported. I hadn't tried "Array" until just now, but that doesn't work either.

Thanks,
Jason



Just one thing... the type of an array of strings ...

2006-11-21T15:06:00.000-06:00

Just one thing... the type of an array of strings in Ruby is not String[], it is Array.

(String[] actually means calling the method called "[]" on the object called "String", which is not what you want. And there's only one array type in Ruby; Ruby's arrays will gladly accomomdate any object. This is one of the things that was hard to grok for me when I first wrote some Ruby code because I was used to type systems like Java's/C++'s. And Ruby's is just different/insane/wonderful. Anyway, I hope this little digression helps you...)

Perhaps throwing in Array instead of String[] in your first version might work. It should, by the principle of least surprise, but then I don't know the OCI8 driver.