Executing an Oracle stored procedure

ruby-talk
1

Hi all,

Ruby 1.8.2
OCI8

I'm spacing - how do I call an Oracle stored procedure using DBI/OCI8?
I tried a few things, but no luck.

Thanks.

Dan

2

Daniel Berger wrote:

Hi all,

Ruby 1.8.2
OCI8

I'm spacing - how do I call an Oracle stored procedure using DBI/OCI8?
I tried a few things, but no luck.

Thanks.

Dan

Nevermind - got it.

It's dbh.prepare("begin my_proc; end;")

Don't forget that trailing semicolon.

Regards,

Dan