Suma Venkatesh wrote:
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 Health Language, Inc.