Skip to Content
Apr 16, 2004 at 06:17 PM

Executing Oracle Stored Procedure from EP6


Has anyone had any experience executing Oracle Stored Procedures using JDBC from the EP6 Portal?

I am able to establish a connection to my database, and perform queries and display results OK.

I need to execute a stored proc which takes some input parameters, and returns a record set of results within a refcursor. I can create an iView within the Portal using the wizard, and execute the proc and get my results, but I'm trying to do this from my Java code.

I have tried implementing the example found on the SDN for executing an existing function, but with no luck.

Any help would be greatly appreciated.