Suma -- Stored procedures are only supported for data persistence operations (insert, update or delete). Data retrieval (i.e. select) is still performed by 'basic' sql statements.
Ron Gallagher Atlanta, GA [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, January 10, 2004 4:39 AM To: OJB Users List Subject: [Fwd: How to call a select store procedure in OJB] -------- Original Message -------- Subject: How to call a select store procedure in OJB Date: Fri, 9 Jan 2004 14:56:15 -0800 (PST) From: Suma Venkatesh <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Hi 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 ? thanks in advance, suma ------------------------------------------------------------------------ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes <http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/mail_footer_email/evt=2 1482/*http://hotjobs.sweepstakes.yahoo.com/signingbonus> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]