Everything about developing software is not on a "web site" waiting for you to find it with a ?oogle search.
If you learn about how to implement the Data Access Object design pattern and know how to program Enterprise JavaBeans, then you should not have any problem with executing a stored procedure from an Enterprise JavaBean.
Below is a guide to help you find what you are looking for.
the architecture is like struts-->ejbSessionBeans(Remotely)-->ejbEntityBeans(locally calling from sessionbeans ).
the above architecture is giving performance issue because there are looping business logic from session to entitybeans, so network tropic is arrived,
now i have to change my architecture for some part(2 or 3 sessionbeans) where the looping concept is came. the architecture is would be struts--->sessionbeans----> PL/SQL Stored Procedure(Replace with Entity Beans),
1) so we need to write pl/sql stored procedure code(is required any configuration in ejb-jar.xml or else?)
2)how to access that pl/sql code in our SessionBeans?
3)how to do all thease configurations?
could you please tell me with example code if any body knows?