On Tue, Apr 21, 2009 at 6:34 PM, OpenDBX devel list <
libopendbx-devel@lists.sourceforge.net> wrote:
> Hi Mariano, Berto
>
> > We wants to use store procedures with large objects in MySQL for example.
> >
> > All I know about SP is that I should enable multistatements and query all
> > the results. But I never had the time to test them.
> >
> > Do you have same advice about this ?
>
> Yes, stored procedures work and should work with large objects too, but I
> also haven't tested this before. If it works using the MySQL client
> library,
> it should also work with OpenDBX. If not, I will try to fix it.
>
> You are right with your advices. You must enable the "multiple statements"
> option (odbx_set_option()) and retrieve all result sets (odbx_result()
> until
> it returns ODBX_RESULT_DONE resp. 0).
>
Thanks for the help Norbert.
I was just reading this:
http://dev.mysql.com/doc/refman/5.0/en/stored-routines-syntax.html
and this: http://dev.mysql.com/doc/refman/5.0/en/call.html
As you say, MySQL client library support SP.
I will give it a try as soon as possible.
Cheers,
Mariano
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today.
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> libopendbx-devel mailing list
> libopendbx-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>
------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
