Re: Working on store procedure

[Larry V. Streepy, Jr.]

As has been stated a couple of times, there  is no support for directly specifying the use of a stored procedure so that OJB will use it for data retrieval.  However, I would expect that you could write the SP so that it returns a set of OIDs which you could then use to quickly materialize the objects. [EMAIL PROTECTED] wrote: Hi I posted the below question 3 days ago. Is it that new joiners are not answered OR is my question too obvious !!! Iam completely new to OJB and trying to learn it. Please help me. Iam working on using store procedures using OJB. I want to call a store procedure which selects a number of items from a table Product.I want to be able to use a store procedure to do this and not a simple select and query by collection. I checked the repository.dtd which defines no such element. Is there a way to acheive this in OJB ? To summarize: How to call a custom store procedure in OJB which does NO insert,update and delete operations. thanks in advance, suma This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Larry V. Streepy, Jr. Senior Vice President and CTO "We speak the language of healthcare" ™ Direct: +1 425-373-0600 Fax:    +1 425-373-1633 Corp.:  +1 303-307-4400 Health Language, Inc. 3950 Lewiston Street, Suite 210 Aurora, Colorado 80011 The information in this email message is intended only for the use of the intended recipient and may contain confidential information. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Health Language's corporate offices in Aurora, Colorado USA at (+1) 303-307-4400.

<<inline: HL_PMS_smaller.jpg>>