I checked in oracle_basic.c and there seems to be some places related to
BLOB or CLOB that are commented....maybe something related to that :)
Cheers
Mariano
On Sat, Feb 13, 2010 at 8:38 PM, Mariano Martinez Peck <
marianop...@gmail.com> wrote:
>
>
> On Sat, Feb 13, 2010 at 7:54 PM, Mariano Martinez Peck <
> marianop...@gmail.com> wrote:
>
>>
>>
>>> > 2) I need to know for all the backends, which ones use normal functions
>>> and
>>> > which ones the special functions
>>>
>>> Firebird provides odbx_lo_* capabilites and Oracle could but I didn't get
>>> it
>>> to work without segfault. All other backends use the regular functions to
>>> manage large texts or blobs.
>>>
>>>
>> So, with Oracle there is no way to use large objects through OpenDBX by
>> the moment because the only way is using the special functions and you are
>> having segmentation fault with them ? Or I can also use normal functions
>> for large objects in Oracle ?
>>
>>
> Ok...more tests.
>
> I could do this, using the NORMAL functions:
>
> CREATE TABLE test_large_columns (
> large_clob CLOB,
> large_nclob NCLOB,
> ).
>
> INSERT INTO test_large_columns (large_clob, large_nclob)
> VALUES (''large_clob_data'' , ''large_nclob_data'' )
>
> SELECT * FROM test_large_columns
>
>
> That works without problems. My main problem is when the type is binary,
> for example a BLOB. How can I insert a BLOB trough OpenDBX ? because OpenDBX
> expects a char* as the query..... I see two solutions:
>
> 1) The database automatically converts the char or string into a BLOB ? I
> think MySQL do that.
>
> 2) Use database functions to convert a tring to a BLOB value. I guess I
> need to do something similar in Oracle, but I don't know how.
>
> I have just tried this:
>
> CREATE TABLE test_large_columns (
> large_clob CLOB,
> large_nclob NCLOB,
> large_blob BLOB
> ).
>
> INSERT INTO test_large_columns (large_clob, large_nclob, large_blob)
> VALUES (''large_clob_data'' , ''large_nclob_data'' , EMPTY_BLOB())
>
> SELECT * FROM test_large_columns
>
>
> But when I am trying to fech the raw, using odbx_row_fetch I get the
> error:
> 'ORA-00932: inconsistent datatypes: expected CHAR got BLOB'
>
> I put EMPTY_BLOB() because I don't know even how to put a CLOB :(
>
> Ok....I am a bit lost :(
>
> Thanks
>
> Mariano
>
>
>
>
>
>
>
>> If there is no way, shouldn't we need to change this:
>>
>>
>> http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes#Large_object_types
>>
>> Thanks for the clarification.
>>
>> Mariano
>>
>>
>>
>
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
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
