Page 1 of 1

Clobs Blobs and Mobile OraDirect.NET

Posted: Mon 02 Jul 2007 03:19
by wambie
In general I have been very happy the OraDirect product for both the mobile and desktop and has saved me a lot of hard work doing this all for myself. Thanks for that!

I am using OraDirect .NET mobile version 3.55.19.0 and I have not found any support for passing clobs/blobs to stored procedures on an the Oracle 10g database. I can receive a clob/blob to the handheld but I cannot pass it back to the database. Am I missing something?

The data I am trying to save from the handheld to the database is in XML format and varies in size from 1K to 500K. I would like a clean way to do this using an Oracle Stored procedure. Does anyone have any suggestions on how to go about this?

Does the 4.0 version of the Mobile OraDirect library support sending Clobs/Blobs?

Many thanks,
Gary.

Posted: Mon 02 Jul 2007 06:56
by Alexey
Please take a look at our sample project
%ProgramFiles%\CoreLab\OraDirect.NET\Samples\Clob\CS\Clob.sln