Hi Ron,thomas and Larry Thank you so much for the response. I did not receive any answers prior to todays email and hence was my frustration.Sorry about that. If OJB doesnt support a store procedure performing only selects, can i atleast call a custom store procedure ? Larry's answer: 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. @@How to call this SP which would return OIDs.I mean in which tag should the call be placed in repository_user.xml Is it under <insert-store procedure>,<update-store procedure> OR <delete-store procedure> because i think the broker calls them based on the operations they perform. Let me know. thanks in advance, suma
"Larry V. Streepy, Jr." <[EMAIL PROTECTED]> wrote: 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 Colorado USA at > (+1) 303-307-4400. ------------------------------------------------------------------------ >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, --------------------------------- Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
