Hi,

I am currently creating reports using MyEclipse Report and things are going well for me, but I now need to use stored procedure instead of SQL request. Unfortunately I can’t figure out how! I saw in the BIRT tutorial see link below that it is possible to use stored procedure by choosing Stored procedure option from the "Data Set Type" dropdown menu when creating a data set. But the only option available for me is "MyEclipse Data Set".

http://help.eclipse.org/help31/index.jsp?topic=/org.eclipse.birt.doc/birt/birt-04-05.html

So first I would like to know if it is actually possible to use stored procedure with MyEclipse Reports and if so how!

Any help would be much appreciated.

Thanks,
Maturin

Quote:

So first I would like to know if it is actually possible to use stored procedure with MyEclipse Reports and if so how!

Have you taken a look at this:-
http://wiki.eclipse.org/StoredProcedure_(BIRT)#Stored_Procedure_SQL

Hi, Thank you very much for your answer, I actually did look at this page before! But stupid me, I did not realize that I was suppose to use the characters "{}" around the procedure call so I was getting an error message, It is working perfect now! Thanks for pointing me to this page again so I could find my problem.

Maturin

Your Welcome.

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

WAG - Call it from inside a select?