Executing an Oracle stored procedure

D

Daniel Berger

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
 
D

Daniel Berger

Daniel said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,899
Latest member
RodneyMcAu

Latest Threads

Top