Hi experts

Someone can help me to allow me call a PL/SQL Procedure storaged in the Data Base from EJB in JDeveloper? I need the syntax and what happend if the store procedure has parameter... Well I sayd Procedrures not Functions...

And I need to do the following statement into NAMED QUERY
select distinct a.field, b.field
from a inner join b
where a.fiel2 = b.field2
and a.field in (select c.field
from c)

I'm thinking that Jdeveloper 10g is not easy to use because in the web no body knows about tips... OK the applications run more faster in web and look well but the development environment uuff...

I feel confuse...

Thanks to all, please feel free to contact me to = jbernal72@hotmail.com

"I'm thinking that Jdeveloper 10g is not easy to use because in the web no body knows about tips... "

Yes, JDeveloper a professional tool, not for beginners.

Yes, you can invoke a PL/SQL stored procedure with EJB using a data access object.

Also see here.

http://www.odbms.org/download/020.01%20Ard...mber%202005.PDF

Ok I accept that I'm beginner in Jdeveloper but all people need to learn the new development options so, I have ten years using Oracle Forms, Report etc now we are going to change to JDEVELOPER and I need some concepts ...

I understant your point of view but no always we hava to pay by some information because some times ago I did received the syntax of a lot of questions

Thanks for your help.. .I will continue asking to somenone...

Hi,

You mentioned web services, and I found this. It's not JDeveloper but it has a working example:

http://www.oracle.com/technology/pub/artic...rice_10gws.html