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.
It should be fairly simple to execute store procedures from Portal. Using DBPool get a connection object to the database. Once you have the connection object you can execute a procedure that returns a cursor. It is like executing a procedure from any other java code. Don't think that portal makes a difference here.