Hi!

Multistatement is okay, that's just to make sure the API knows what to do.
But beware that retrieving TEXT/BLOB fields as parameters sometimes may be
far from easy, due to the fact that you have no idea of the actual lenght.
PHP basically cannot do it, so I wonder if openDBX can. Let me know.

Berto

2009/4/21 Mariano Martinez Peck <marianopeck at gmail.com>

>
>
> On Mon, Apr 20, 2009 at 7:25 PM, Bèrto ëd Sèra <berto.d.sera at gmail.com>wrote:
>
>> Hi!
>>
>> Compliments! FMI, is there any support for stored procedures, stored
>> functions and IN OUT parameter passing with MySQL 5.1?
>>
>
> Thanks! More or less. At least, it is not tested. However, as you can see
> in: http://wiki.squeak.org/squeak/6106 we plan to do it in a future.
>
> When I asked Norbert (openDBX author) about openDBX store procedure
> support, he told me "You have to enable the multi-statement option and
> retrieve all result sets using odbx_result. ". This, in SqueakDBX means:
> DBXConnection #enableMultiStatements and then do #execute: aSQLString.
>
> I guess in this case aSQLString can be the call string to SP, but I really
> don't know.
>
> So, perhaps we do support SP but we don't know it. Is just a matter of
> testing. If you want I can google and see how to create a simple SP and see
> If I can call it and retrieve the results.
>
> Cheers,
>
> Mariano
>
>
>> Thanks
>> Berto
>>
>>
>>
>>
>
>
>
>


-- 
==============================
Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole les
droits du peuple, l'insurrection est, pour le peuple et pour chaque portion
du peuple, le plus sacré des droits et le plus indispensable des devoirs.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeak-dev/attachments/20090421/a0429652/attachment.htm