facebook

Select stored procedure option not showing in Data Set Type

  1. MyEclipse Archived
  2.  > 
  3. MyEclipse Reports
Viewing 15 posts - 1 through 15 (of 21 total)
  • Author
    Posts
  • #303013 Reply

    Hi,
    I have an Oracle 10g Database and I am trying to call the stored procedure with MyEclipse Reports, unfortunately it doesn’t give me the option to select stored procedure in Data Set Type, since the only option that I have is SQL Select Query. How can I call the stored procedure, if I don’t have the option in Data Set Type?
    Any help would be much appreciated.
    Thank you,
    Sofia

    #303067 Reply

    Loyal Water
    Member

    Sofia,
    Can you go to MyEclipse > Installation Summary > Installation Details and paste them here for me. I will get some one from the dev team to look into this issue.

    BTW I hope these are the steps you followed:-
    http://www.birt-exchange.org/devshare/designing-birt-reports/447-using-stored-procedures-with-birt/#description

    #303069 Reply

    Hello,

    Below are the installation details. I followed the steps in the link below and it didn’t work.

    *** Date:
    Wednesday, October 7, 2009 1:20:34 PM EDT

    ** System properties:
    OS=WindowsXP
    OS version=5.1.0
    Java version=1.6.0_13

    *** MyEclipse details:
    MyEclipse Enterprise Workbench
    Version: 8.0M1
    Build id: 8.0M1-20090924

    *** Eclipse details:
    MyEclipse Enterprise Workbench

    Version: 8.0M1
    Build id: 8.0M1-20090924

    Eclipse startup command=-os
    win32
    -ws
    win32
    -arch
    x86
    -showsplash
    -launcher
    C:\Program Files\Genuitec\MyEclipse 8.x Latest\myeclipse.exe
    -name
    Myeclipse
    –launcher.library
    C:\Program Files\Genuitec\MyEclipse 8.x Latest\../Common/plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.200.v20090519\eclipse_1206.dll
    -startup
    C:\Program Files\Genuitec\MyEclipse 8.x Latest\../Common/plugins/org.eclipse.equinox.launcher_1.0.200.v20090520.jar
    -clean
    -install
    C:/Program Files/Genuitec/MyEclipse 8.x Latest
    -configuration
    configuration
    -clean
    -vm
    C:/Program Files/Genuitec/Common/binary/com.sun.java.jdk.win32.x86_1.6.0.013/jre/bin/client/jvm.dll

    Thanks,
    Sofia

    #303114 Reply

    Any news to the above issue?

    Thanks,
    Sofia

    #303119 Reply

    Loyal Water
    Member

    Sofia,
    Im afraid the person who would be looking into this issue is on leave today. I will get him to reply to your post first thing tomorrow.

    #303190 Reply

    Hi Nipun,

    Do you have any news about the issue?
    I need to finish my project as soon as possible.
    Thanks,
    Sofia

    #303197 Reply

    Brian Fernandes
    Moderator

    Sofia,

    Sorry for the delayed response.
    I’m afraid that for this functionality, a special data set type – “The Stored Procedure Query” type is required, which is not currently support by the MyEclipse Data Source. I cannot recommend any workarounds right now, currently MyEclipse Reports will only support standard select JDBC.

    I have filed a feature request to add support for this query type, but cannot commit to an availability date.

    Please let us know if you have further queries or need assistance, sorry for the inconvenience caused.

    #303227 Reply

    Hi Brian,

    Do you know if I can use another reporting tool that will work with oracle stored procedures? I know that Jasper doesn’t support it either.
    Do you know If I can use microsoft reporting services instead of birt and send the parameters from my jboss-seam application?

    Thanks,
    Sofia

    #303322 Reply

    Brian,

    I managed to pull the data from the oracle stored procedure in the birt report by creating a stored function to retrieve the results of the stored procedure.
    I have a question, how do you send the parameters and call the birt report from the jboss-seam application? Do you have an example?

    Thanks,
    Sofia

    #303350 Reply

    Loyal Water
    Member

    This message has not been recovered.

    #303353 Reply

    Brian Fernandes
    Moderator

    This message has not been recovered.

    #314410 Reply

    jbain
    Member

    Is there any timeframe of getting the Stored Procedure Query option in the Data Set Types back?
    I know the option is there in Eclipse but not in MyEclipse.

    #314435 Reply

    jbain
    Member

    I am new to MyEclipse and have done my research looking for any means to call a stored procedue in Oracle.

    I am currently using MyEclipse 8.6.1 and have even downloaded and configured MyEclipse 9.0 M2 to see if the functionality allowing me to choose the SQL Stored Procedure Query as an elibile data set type but it does not.

    In my research I have downloaded Eclipse 3.3.2 with the BIRT 2.2.2 plugin the option to choose SQL Stored Procedure Query is there and it woks great. However, we are not using that tool.

    Why would this functionality be there in an old version of Eclipse and when I am using MyEcllipse 9.0 M2 with an Eclipse Engine 3.6.1 the functionality is not there.

    I have tried to get around this by configuring the Oracle OCI driver in MyEclipse (thinking that it would run native Oracle SQL server side) and it configured successfully but the Data Set functionality will still not allow me to call the function I created even within a SQL statement. It is as if it can not see the function.

    If you can direct me in any way I would greatly appreciate it.

    Take care,

    John

    #314436 Reply

    jbain
    Member

    I am new to MyEclipse and have done my research looking for any means to call a stored procedue in Oracle.

    I am currently using MyEclipse 8.6.1 and have even downloaded and configured MyEclipse 9.0 M2 to see if the functionality allowing me to choose the SQL Stored Procedure Query as an elibile data set type but it does not.

    In my research I have downloaded Eclipse 3.3.2 with the BIRT 2.2.2 plugin the option to choose SQL Stored Procedure Query is there and it woks great. However, we are not using that tool.

    Why would this functionality be there in an old version of Eclipse and when I am using MyEcllipse 9.0 M2 with an Eclipse Engine 3.6.1 the functionality is not there.

    I have tried to get around this by configuring the Oracle OCI driver in MyEclipse (thinking that it would run native Oracle SQL server side) and it configured successfully but the Data Set functionality will still not allow me to call the function I created even within a SQL statement. It is as if it can not see the function.

    If you can direct me in any way I would greatly appreciate it.

    Take care,

    John

    #314437 Reply

    jbain
    Member

    I am new to MyEclipse and have done my research looking for any means to call a stored procedue in Oracle.

    I am currently using MyEclipse 8.6.1 and have even downloaded and configured MyEclipse 9.0 M2 to see if the functionality allowing me to choose the SQL Stored Procedure Query as an elibile data set type but it does not.

    In my research I have downloaded Eclipse 3.3.2 with the BIRT 2.2.2 plugin the option to choose SQL Stored Procedure Query is there and it woks great. However, we are not using that tool.

    Why would this functionality be there in an old version of Eclipse and when I am using MyEcllipse 9.0 M2 with an Eclipse Engine 3.6.1 the functionality is not there.

    I have tried to get around this by configuring the Oracle OCI driver in MyEclipse (thinking that it would run native Oracle SQL server side) and it configured successfully but the Data Set functionality will still not allow me to call the function I created even within a SQL statement. It is as if it can not see the function.

    If you can direct me in any way I would greatly appreciate it.

    Take care,

    John

Viewing 15 posts - 1 through 15 (of 21 total)
Reply To: Select stored procedure option not showing in Data Set Type

You must be logged in to post in the forum log in