Skip to Content
author's profile photo Former Member
Former Member

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 16, 2004 at 06:25 PM

    Hi Doug,

    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.

    Lakshmi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Doug,

      Seems like the jar file is not there in Portal's classpath. You have two options to resolve this. Add the Jar file to the portal classpath. You can do this from the console. The second way to do this would be to create a par file with just the jar file (that contains Oracle Type). Upload the par file into the portal. In Service Ref of the portal component that actually connects to the database add the par file.

      Hope this helps.

      Lakshmi

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2004 at 01:16 PM

    Doug,

    What do you have for Connection URL and Driver Class Name when creating an iView within the Portal using the wizard?

    Thanks in advance

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.