Erol, I don’t know of a way to set this dynamically (though there might be some method of doing this…) Are you saying you need to have the proprietary Oracle XMLType returned sometimes, and the JDBC standard SQLXML type object others? I’d stick with the standard if you can.

Scott

From: Erol Akarsu [mailto:eakarsu@gmail.com]
Sent: Wednesday, May 07, 2014 1:37 PM
To: Bednar, Scott E
Cc: Dirk Kirsten; basex-talk@mailman.uni-konstanz.de
Subject: Re: [basex-talk] Oracle blob

Scott,

I want  this setting for only importing blob data but doesn't need all other times,

>set PROPS=-Doracle.jdbc.getObjectReturnsXMLType="false"

Is there a way to turn on and off for this setting in basex application instead of setting it globally?

Thanks

Erol Akarsu

On Wed, May 7, 2014 at 4:13 PM, Bednar, Scott E <scott.e.bednar@boeing.com> wrote:

My experience has been limited to extracting XML CLOBs from Oracle, however some of the setup information I posted may be of use:

https://mailman.uni-konstanz.de/pipermail/basex-talk/2014-March/006507.html

Also, you might take a look at the Oracle documentation for LOB creation in JDBC 4.0:

http://docs.oracle.com/cd/E18283_01/java.112/e16548/jdbcvers.htm#BCFIDIEH

I’m not sure BaseX supports this JDBC interface or not, but it did for XML extraction.

Thanks, Scott

From: Erol Akarsu [mailto:eakarsu@gmail.com]
Sent: Wednesday, May 07, 2014 12:56 PM
To: Dirk Kirsten; Bednar, Scott E
Cc: basex-talk@mailman.uni-konstanz.de
Subject: Re: [basex-talk] Oracle blob

Scott,

Can you please share your experience?

Thanks

On Wed, May 7, 2014 at 3:43 PM, Dirk Kirsten <dk@basex.org> wrote:

Hello Erol,

Some time ago we had a short discussion on the ML about using clob with
Oracle:
https://mailman.uni-konstanz.de/pipermail/basex-talk/2014-March/006481.html

Blob is even a standard java.sql type and should work fine. If not,
don't hesitate to report a bug here.

Cheers,
Dirk

PS: Next time you might want to start a new conversion with a different
title... makes stuff easier to find in the future for other people,
which might run into the same problem.

On 07/05/14 21:35, Erol Akarsu wrote:
> Thanks Marco,
>
> I have another question.
> I am trying to use Basex's SQL functions. I have tried some basic SQL
> commands for connecting and selecting some rows from table, it works fine.
>
> For my project, I need to upload and export pdf document/word
> doc/images  form/into Oracle database that needs some special
> oracle-specific stuff.
> Has anybody tried to upload blob/digital document to Oracle with Basex?
> I appreciate any help
>
> Erol Akarsu
>
>
> On Tue, May 6, 2014 at 2:07 PM, Marco Lettere <marco.lettere@dedalus.eu
> <mailto:marco.lettere@dedalus.eu>> wrote:
>
>     Hi Erol,.
>     try
>
>     element book {
>
>       for $i in 1 to 4
>       return attribute {xs:QName("isbn_" || $i)} { "value" || $i}
>
>     }
>
>     Regards,
>     Marco.
>
>
>     On 06/05/2014 19:48, Erol Akarsu wrote:
>
>         I would like to create an xml element that will have dynamic
>         number of attributes, something like this where n will change
>         and $value_1 to $value_2 will be provided by outside
>
>         element book {
>          attribute isbn_1 {$value_1}
>         attribute isbn_2 {$value_2}
>         attribute isbn_3 {$value_3}
>         .
>         .
>         .
>         attribute isbn_n {$value_n}
>         }
>
>         Can we do it?
>
>         Thanks
>
>
>

--
Dirk Kirsten, BaseX GmbH, http://basex.org
|-- Firmensitz: Blarerstrasse 56, 78462 Konstanz
|-- Registergericht Freiburg, HRB: 708285, Geschäftsführer:
|   Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle
`-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22