Suma -- At this point, OJB's support for stored procedures is limited to just data persistence operations (insert, update or delete). Data retrieval (i.e. select) is still performed by 'basic' sql statements. I am aware of no plans at this time to extend SP support to handle data retrieval.
Ron Gallagher Atlanta, GA [EMAIL PROTECTED] -----Original Message----- From: Suma Venkatesh [mailto:[EMAIL PROTECTED] Sent: Sunday, January 11, 2004 6:07 PM To: OJB Users List Subject: Calling custom store procedures in OJB Hi all, 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: Is there a way to call a custom store procedure which does NO insert,delete,update operations and just does some select operations in OJB. Please help me as Iam totally new to OJB!! thanks in advance, suma --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]